Re: Date sorting
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 26482
interpreted = N
texte = >How do I sort the results descending by date based on a field where >the date has been recorded as day.month.year (01.01.2000)?First, change the name of your 'date' field to something other than 'date' -- such as 'itemDate' for example. You should never use webdna tags names as db field names.Then, assuming your date preferences match your date format, just add &itemDateType=date to your search parameters:&db=../data/classifieds.db &cart=[cart] &neUniqueIddata=0 &eqcountrydatarq=n &neUniqueIddata=0 &eqsexdatarq=female &has_photosort=1 &has_photosdir=de &itemDatesort=2 &itemDatesdir=de &itemDateType=date <-- add this parameter &searchtitle=[url]female[/url] &max=10 &language_id=[language_id] &country_id=[country_id]================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to
.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
Associated Messages, from the most recent to the oldest:
>How do I sort the results descending by date based on a field where >the date has been recorded as day.month.year (01.01.2000)?First, change the name of your 'date' field to something other than 'date' -- such as 'itemDate' for example. You should never use webdna tags names as db field names.Then, assuming your date preferences match your date format, just add &itemDateType=date to your search parameters:&db=../data/classifieds.db &cart=[cart] &neUniqueIddata=0 &eqcountrydatarq=n &neUniqueIddata=0 &eqsexdatarq=female &has_photosort=1 &has_photosdir=de &itemDatesort=2 &itemDatesdir=de &itemDateType=date <-- add this parameter &searchtitle=[url]female[/url] &max=10 &language_id=[language_id] &country_id=[country_id]================================ Kenneth Grome, WebDNA Consultant 808-737-6499, http://webdna.net ================================------------------------------------------------------------- Brought to you by CommuniGate Pro - The Buzz Word Compliant Messaging Server. To end your Mail problems go to .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
Kenneth Grome
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:
[WebDNA] fast free WebDNA hosting + web based IDE (2015)
RE: URL too Long? (1997)
WebTEN vs webSTAR have you seen this? (1998)
WebCat for Unix?? (1997)
TaxTotal (2003)
Security Levels... Possible? (2000)
[NT] ie 4.0 required (1997)
WebCommerce: Folder organization ? (1997)
Document Contains No Data! (1997)
RE: webcat license???? (1997)
Replace Statement (1997)
Database Term [brainfart] (2003)
Avery 5160 Mailing Labels (2003)
Webcat/Webmerchant part II (1998)
Upgrading to 10.1.5 (2002)
The beginning (1997)
Where's Cart Created ? (1997)
Hard Questions ? (1997)
GuestBook example (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)