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:

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)