Re: Sorting search by date.
This WebDNA talk-list message is from 2000
It keeps the original formatting.
numero = 30346
interpreted = N
texte = >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 ...-- ================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------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:
>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 ...-- ================================Kenneth Grome, WebDNA Consultant808-737-6499 http://webdna.net================================-------------------------------------------------------------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:
FISKARS (2003)
WebCat2b12 - New features for 1.6 users ... (1997)
emailer truncates last letter! (1997)
[OT] Indexing of dynamic web sites (2003)
ShowNext for method=POST (1997)
[BoldWords] WebCat.acgib15Mac (1997)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
sort problems....bug or brain fart? (1997)
[OT] Theiving B*****ds (2004)
Version 2.1.3 changes ... (1998)
WebCatalog can't find database (1997)
WebCatalog for guestbook ? (1997)
Re:listfiles-looking for slick solution (1997)
Dynamic Image Generation (2000)
WebCat2_Mac RETURNs in .db (1997)
page redirect in webDNA (1997)
[DOS] (1999)
Mirroring WebCat Servers (2001)
SKU (1997)
Requiring that certain fields be completed (1997)