Re: Sorting search by date.

This WebDNA talk-list message is from

2000


It keeps the original formatting.
numero = 30348
interpreted = N
texte = You'll find discussion of TYPE in the OnLine Documentation. In the upper left frame link to Searching, then in the lower left frame link to Dates and Numbers, you'll find examples of the use of TYPE with dates and numbers respectively. -----Original Message----- From: Mark Derrick [mailto:mark@mcm.co.uk] Sent: Wednesday, April 12, 2000 6:47 AM To: WebDNA-Talk@talk.smithmicro.com Subject: Re: Sorting search by date. 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 ------------------------------------------------------------- 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)
You'll find discussion of TYPE in the OnLine Documentation. In the upper left frame link to Searching, then in the lower left frame link to Dates and Numbers, you'll find examples of the use of TYPE with dates and numbers respectively. -----Original Message----- From: Mark Derrick [mailto:mark@mcm.co.uk] Sent: Wednesday, April 12, 2000 6:47 AM To: WebDNA-Talk@talk.smithmicro.com Subject: Re: Sorting search by date. 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 ------------------------------------------------------------- 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 Wilkins, John

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:

WebDNA for Dummies (2004) Zip Code Lookups (1999) Email encryption (1998) IE problems persist (2004) Announcement-WebCatalog 2.0 Released (1997) Migrating to NT (1997) RE: Re:Signal Raised (1997) Getting total number of items ordered (1997) CommandSecurity? (1997) [WebDNA] behavior of [thisurl] in the context of 'mod_rewrite' (2012) Quit revisited (1997) eMail volume (2000) Hiccup ***** (1998) ReturnRaw context (1997) WebCat2b13MacPlugIn - More limits on [include] (1997) Behind the Scenes. . . (1998) Re[3]: 2nd WebCatalog2 Feature Request (1996) [SHOWIF] (1997) Multiple Pulldowns (1997) Sitebuilder - Shownext Style (2004)