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:

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)