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 the wrong 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:

    
  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)
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 the wrong 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:

Template not completely processed (1998) Search design (1997) setting cookies then redirecting? (1998) Emailer setup (1997) Bug or syntax error on my part? (1997) Not really WebCat- (1997) Bug or syntax error on my part? (1997) [WebDNA] Email time bug? (2011) Emailer setup (1997) Enhancement Request for WebCatalog-NT (1996) [Announce]: Web server security and password protection (1997) RE: storefront (1998) Hide Cart ID in URL? (2003) PCS Frames (1997) [WriteFile] problems (1997) Emailer (1997) Nested tags count question (1997) RE: protect tag not working (1998) PIXO support (1997) WebCat-based Chat (2000)