Sorting search by date.

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 30345
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?Thanks. ------------------------------------------------------------- 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?Thanks. ------------------------------------------------------------- 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:

File Upload (1997) How do I get Google to crawl a WebCat site? (2003) SiteEdit NewFile.html ? (1997) Looping control (1997) Time since application launch (1999) A multi-processor savvy WebCatalog? (1997) RAM variables (1997) WC2f3 (1997) getchars broken? (1997) ConvertChars (2000) RePost: NAT and the CART (1999) WebDNA tags in WebMerchant email templates ... (1997) Credit Card Checking?? (1998) Can't use old cart file (was One more try) (1997) Using Protection =) (2003) [shownext] and descending order (1997) anyone have an automated template encrypter? (2000) Ampersand is breaking search context (1999) problems with WebCat-Plugin (1997) WebDNA Intranet Edition public demo (2002)