Re: Searching - FIELDNAMEtype=date FIELDNAMEtype=time
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55806
interpreted = N
texte = I suspected that answer, well aside from the monkey ;-) I also assumed, but not tested, that if it is not set at all i.e. "FIELDNAMEtype=" is would also do a text search.Thanks,MattBrian Fries wrote:> You can say "FIELDNAMEtype=text" to treat it as text; then again you > can also say "FIELDNAMEtype=monkey" and it will treat it as text. > Basically, if it's not set to "date", "time" or "num" then it will be > treated as text.>> - brian>> On Jan 30, 2004, at 9:40 AM, Matthew A Perosi wrote:>>> According to the docs:>>>>>> WebDNA normally compares all fields in a database as though they were >> text, even if they look like dates to you. Unless you tell it to >> compare a field as a date (or as a time or anumber), all comparisons >> are alphabetical.>> So this means you can specify:>> FIELDNAMEtype=date>> FIELDNAMEtype=time>> FIELDNAMEtype=num>>>> I know it's a strange question but is there a way to specify>> FIELDNAMEtype=alpha or FIELDNAMEtype=text>>> -- Brian Fries, BrainScan Software -- > http://www.brainscansoftware.com -->>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list
.> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/>-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
I suspected that answer, well aside from the monkey ;-) I also assumed, but not tested, that if it is not set at all i.e. "FIELDNAMEtype=" is would also do a text search.Thanks,MattBrian Fries wrote:> You can say "FIELDNAMEtype=text" to treat it as text; then again you > can also say "FIELDNAMEtype=monkey" and it will treat it as text. > Basically, if it's not set to "date", "time" or "num" then it will be > treated as text.>> - brian>> On Jan 30, 2004, at 9:40 AM, Matthew A Perosi wrote:>>> According to the docs:>>>>>> WebDNA normally compares all fields in a database as though they were >> text, even if they look like dates to you. Unless you tell it to >> compare a field as a date (or as a time or anumber), all comparisons >> are alphabetical.>> So this means you can specify:>> FIELDNAMEtype=date>> FIELDNAMEtype=time>> FIELDNAMEtype=num>>>> I know it's a strange question but is there a way to specify>> FIELDNAMEtype=alpha or FIELDNAMEtype=text>>> -- Brian Fries, BrainScan Software -- > http://www.brainscansoftware.com -->>> -------------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > To switch to the DIGEST mode, E-mail to > > Web Archive of this list is at: http://webdna.smithmicro.com/>-------------------------------------------------------------This message is sent to you because you are subscribed to the mailing list .To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Matthew A Perosi
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
how does [break] work? (1998)
[shownext max=?] armed (1997)
cybercash on OSX - was Executing remote AppleScript (2000)
lookups or math? (1998)
mass mailing (1998)
Kaaaaahhhhhhhnnnnnnn! (1997)
syntax question, not in online refernce (1997)
Separate SSL Server (1997)
Authorize.net has gone flooey (2006)
Roundup function? (1997)
Cookies and webcat (1997)
Hiding Contexts (2000)
URGENT! ACGI Stopped!!!! (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
international time (1997)
WebCat Problem? (1999)
Setting up shop (1997)
Re1000002: Setting up shop (1997)
limit to listwords (2001)
Images in WebCat (2000)