Searching - FIELDNAMEtype=date FIELDNAMEtype=time

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55801
interpreted = N
texte = 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 a number), 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
------------------------------------------------------------- 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)
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 a number), 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
------------------------------------------------------------- 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:

Can't access globals folder (2003) Listserver problem (1997) Emailer [cart] file names (1997) Mixing and/or in searches (1998) too many nested tags ... (1997) This Code Kills My WebCatalog Dead (2003) [WebDNA] Secure Cookies (2009) WebCommerce: Folder organization ? (1997) Custom Convertchars Database (2004) Where's Cart Created ? (1997) (1997) Banners (1997) OK, here goes... (1997) A link and two command (1998) 2.1 pricing? (1998) Search in 2 or more catalogs (1997) Template Cache problem (2000) FORMS: Returning a specific page (1997) Quitting WebMerchant ? (1997) File Uploads: WebCat/SiteEdit (1998)