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:

WebCatalog2 Feature Feedback (1996) WebCatalog can't find database (1997) SOP for WebDNA talk - MSNBot Crashing (2004) flash-wc (2000) WebCatalog can't find database (1997) webcat error message - what does this mean? (2002) [searchString] (1997) Error 11 (1996) PayFlow Pro - Changing the Amount that was Authorized (2003) using WebCat for Associate Programs? (1998) WebCat2 Append problem (B14Macacgi) (1997) looping through the headers of an orderfile (2000) View order not right (1997) OT-JS why it does not run on Mac (2001) Something about defining variables (1998) Mac OS X problem (2003) strange result? (2003) Upload Maximum (2003) Emailer setup (1997) Separate SSL Server (1997)