Re: Searching - FIELDNAMEtype=date FIELDNAMEtype=time

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55808
interpreted = N
texte = Ah, so that's the trick... I've been trying (unsuccessfully) to sort by monkey for years now... :) -Dan On Fri, 30 Jan 2004 11:12:16 -0800 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/ ------------------------------------------------------------ http://www.StrongGraphicDesign.com http://www.SearchBoise.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)
Ah, so that's the trick... I've been trying (unsuccessfully) to sort by monkey for years now... :) -Dan On Fri, 30 Jan 2004 11:12:16 -0800 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/ ------------------------------------------------------------ http://www.StrongGraphicDesign.com http://www.SearchBoise.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/ "Dan Strong"

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:

file upload (2001) Referrer (2000) encrypt but with normal characters for result? (2005) Summing fields (1997) Date search - yes or no (1997) looking for some paid WebCatalog help (2000) Using WC for Bulk Emailings (1997) [sendmail] questions... (1997) Re:2nd WebCatalog2 Feature Request (1996) Pager notification of completed orders (1998) [WebDNA] [raw] tag with [interpret] question (2010) $Quit, $CloseDatabase corrections (1997) Beta and new version questions? (1998) WebCat2b15MacPlugin - showing [math] (1997) Mac installer (2000) WC2.0 Memory Requirements (1997) Re:TARGET=window_name (1996) Part Html part WebDNA (1997) default value from Lookup (1997) WebCat2 Append problem (B14Macacgi) (1997)