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 Consultant808-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 Consultant808-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:
Multiple serial numbers (1997)
[defined]ish (1997)
Help name our technology! (1997)
adding up in a db (1997)
carriage returns in data (1997)
WebMerchant 1.6 and SHTML (1997)
Out of the woodwork (2007)
RE: Web Logs (1998)
Subject: Any Newsletters out there (1998)
WebCat2 - Getting to the browser's username/password data (1997)
[UPPERCASE] (1997)
IE4.5 bug FYI (1999)
WebCat2b12 forgets serial # (1997)
PSC recommends what date format yr 2000??? (1997)
Escape the Root! (2002)
[WebDNA] WebDNA 7 (2011)
WebCat2b15MacPlugin - showing [math] (1997)
How To question on setting up downloads (1997)
Upgrading old WebCat Database Files (1997)
setting values (1998)