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, Matt Brian 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:

    
  1. Re: Searching - FIELDNAMEtype=date FIELDNAMEtype=time ( "Dan Strong" 2004)
  2. Re: Searching - FIELDNAMEtype=date FIELDNAMEtype=time ( Matthew A Perosi 2004)
  3. Re: Searching - FIELDNAMEtype=date FIELDNAMEtype=time ( Brian Fries 2004)
  4. Searching - FIELDNAMEtype=date FIELDNAMEtype=time ( Matthew A Perosi 2004)
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, Matt Brian 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)