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:
Price lookup problem - was Cart questions (1997)
(2000)
WebCat2 as a chat server? (1997)
Odd [math] behaviour (2003)
[LOOKUP] (1997)
Question about replacing words (1998)
webcatalog and webmerchant 2.1 (1998)
WebCat2b12 - nesting [tags] (1997)
Re Running Locally (2001)
Authenticate Questions (2003)
[Webcat 2]Next (1997)
[OT] XML data to tab delimited database (2003)
Navigator 4.01 (1997)
WebCatalog-NT?'s (1996)
Stopping bad HTML propagation ? (1997)
International Orders (1998)
Who is doing sign-ups-got it (1998)
WC2b15 - [HTMLx]...[/HTMLx] problems (1997)
RAM variables (1997)
Shownext problems (1999)