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:

Database of Tax Rates? (1997) Line items in table cells (1997) WebCat2 - [format thousands] (1997) syntax question, not in online refernce (1997) [WebDNA] Sorting -- Dealing with Blanks (2008) Is there a max number of fields? (1998) Search Engines (2002) View Source from cache (1997) 4.0x on production server (2000) WebCat 5 Admin Bug (2004) more on quicktime test stuff (1997) php + WebCatalog in same files (2001) completed orders database (1997) Semi-OT: PanIP patent infringement case (2001) [Cart] ... (1997) Error cart approval pending (2005) includes and cart numbers (1997) Multiple 'Users.db' files not possible (1997) Forms Search Questions (1997) Re:2nd WebCatalog2 Feature Request (1996)