Re: Searching - FIELDNAMEtype=date FIELDNAMEtype=time

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55804
interpreted = N
texte = 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/ 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)
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/ Brian Fries

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:

Notepad problems (1998) Help! WebCat2 bug (Ben's input) (1997) Signal Raised Error (1997) authorizenet and netscape (2002) Slightly [OT] - Finding host names (1999) filemaker - orderfile (1997) The & Problem (1998) Re:2nd WebCatalog2 Feature Request (1996) Up and running ... at last !! (1997) searchable list archive (1997) So many lookers, hey smith micro (2003) Show items based on login Password (2003) WC2b15 File Corruption (1997) Multiple catalog databases and showcart (1997) Generating Report Totals (1997) Emails are Stuck (2003) range vs greater than/less than (2003) Plugin or CGI or both (1997) WebCatalog can't find database (1997) Banner DNA (1997)