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 Consultant 808-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:

    
  1. Re: Sorting search by date. (Wilkins, John 2000)
  2. Re: Sorting search by date. (Mark Derrick 2000)
  3. Re: Sorting search by date. (Kenneth Grome 2000)
  4. Sorting search by date. (Mark Derrick 2000)
>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 Consultant 808-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:

[ShowIf] and empty fields (1997) updating checkbox in a db (1998) Help! WebCat2 bug (1997) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) [BULK] [WebDNA] CSS HTML Email Using Emailer (2010) Bug? (1997) [WebDNA] FCKeditor (2009) WebCatalog 2.0 b 15 mac (1997) Two submit buttons ? (1997) webcatalog developers in W. Pa. (1998) WebCatalog/WebMerchant 2.1 (1998) Universal root for WC errors? (1997) Robust WebDNA Job Manager / Accountant (2006) Next (1997) AAAH: stupid sendmail (2001) Need some Java Script Code (2003) emailer truncates last letter! (1997) international time (1997) Mac 2.1b4 unknown error: BadSuffix (1997) FW: Shipping calculations (1997)