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... :)-DanOn 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.comhttp://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:
Ah, so that's the trick... I've been trying (unsuccessfully) to sort by monkey for years now... :)-DanOn 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.comhttp://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)