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:
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)