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:

New NT betas available (1997) Include (1998) [UPPERCASE] (1997) much help needed NEWBIE alert (2000) Format of Required fields error message (1997) [WebDNA] HTTPS and authorization (2018) Fwd: 502 Bad Gateway (1998) Summing fields (1997) [WebDNA] Urgent issues - WebDNA 6.2 under Ubuntu 10.04 (2010) Other then credit cards-how? (1997) Re2: frames & carts (1997) WC2.0 Memory Requirements (1997) apostrophe in search item (1997) # of real domains on 1 web server (1997) WebDNA Downloads (Was file browser) (2002) Bug alert! (1997) OT: Sending email to lots of subscribers (1999) Bug Report, maybe (1997) SMSI BUG: RandSeed broken on 4.0.2 / Mac OS X (2002) [SearchString] usage (1997)