Re: Sorting search by date.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30347
interpreted = N
texte = on 12/4/00 10:09 am, Kenneth Grome at ken@simplewebstores.com wrote:>> Got a small piece of WebDNA that goes through a database, and lists all the>> results according to their date (UK date format).>> It uses the following code:>> >> [search db=database.db&geREFdata=0&asdatesort=1]>> >> Which gives this result:>> >> Result1 - 10/03/2000>> Result2 - 10/03/2000>> Result3 - 10/04/2000>> >> >> As you can see, it's having problems doing a correct sort by date, as it's>> only taking the first part of the date into account, and ignoring the month.>> >> Is there a way of achieving the correct result?> > If you don't tell webcat that REF is a date field, it will sort that> field alphabetically, which is exactly what it's doing now. Try> adding &REFtype=date to your search string ...Thanks very much, works perfect now!I couldn't find that mentioned anywhere in the manual, am I looking in thewrong place?Also, what other type= can be used?Thanks again for your help.Mark.-------------------------------------------------------------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:
on 12/4/00 10:09 am, Kenneth Grome at ken@simplewebstores.com wrote:>> Got a small piece of WebDNA that goes through a database, and lists all the>> results according to their date (UK date format).>> It uses the following code:>> >> [search db=database.db&geREFdata=0&asdatesort=1]>> >> Which gives this result:>> >> Result1 - 10/03/2000>> Result2 - 10/03/2000>> Result3 - 10/04/2000>> >> >> As you can see, it's having problems doing a correct sort by date, as it's>> only taking the first part of the date into account, and ignoring the month.>> >> Is there a way of achieving the correct result?> > If you don't tell webcat that REF is a date field, it will sort that> field alphabetically, which is exactly what it's doing now. Try> adding &REFtype=date to your search string ...Thanks very much, works perfect now!I couldn't find that mentioned anywhere in the manual, am I looking in thewrong place?Also, what other type= can be used?Thanks again for your help.Mark.-------------------------------------------------------------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
Mark Derrick
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:
FEW QUESTIONS (1997)
RE: WebCat and image maps (1997)
[isfolder] and [filename] (1997)
[WebDNA] WebDNA Sciprt for Zipping files? (2012)
webcat2b12 CGI -- Date comparisons (1997)
OT - Spiders and Bots (2000)
really annoying feature (2001)
[shownext max (1997)
(1997)
Not reading code (1997)
re: Large databases in WebCat (1997)
RE: Upload (1998)
Can't ping (problem with [shell]) SOLVED (2006)
Running 2 two WebCatalog.acgi's (1996)
Test (2003)
Bookmarked URL with cart (1998)
How to Display text in empty fields (1997)
Spell Check (2000)
[WebDNA] [OT] WebDNA Wiki - need grammar check / suggestions (2009)
Append..... doesn't (2000)