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 upperleft frame link to Searching, then in the lower left frame link to Datesand Numbers, you'll find examples of the use of TYPE with dates andnumbers respectively. -----Original Message-----From: Mark Derrick [mailto:mark@mcm.co.uk]Sent: Wednesday, April 12, 2000 6:47 AMTo: WebDNA-Talk@talk.smithmicro.comSubject: 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 allthe>> 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, asit's>> only taking the first part of the date into account, and ignoring themonth.>> >> 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 thewrong 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:
You'll find discussion of TYPE in the OnLine Documentation. In the upperleft frame link to Searching, then in the lower left frame link to Datesand Numbers, you'll find examples of the use of TYPE with dates andnumbers respectively. -----Original Message-----From: Mark Derrick [mailto:mark@mcm.co.uk]Sent: Wednesday, April 12, 2000 6:47 AMTo: WebDNA-Talk@talk.smithmicro.comSubject: 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 allthe>> 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, asit's>> only taking the first part of the date into account, and ignoring themonth.>> >> 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 thewrong 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)