Re: Sorting Problems

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55458
interpreted = N
texte = > > >5th Jansome data 1 >6th Jansome data 2 >10th Jansome data 3 > >To restrict my search to max=10 is easy and sort latest first > >RecordDatesort=1&RecordDatesdir=de > >is fine but the results come out "upside down": > >10th Jansome data 3 >6th Jansome data 2 > These are not dates as far as WC is concerned. They're text and are sorted as such. You'll need to revise the db to have some other field on which to sort and tell WC what type of data is in that field. One way would be to add a field to each record in the db that contains a number for each day of the year. DayNumRecordDate 11st Jan 22nd Jan .. .. .. 1010th Jan etc. You could then sort using DayNumsort=1&DayNumsdir=de&DayNumtype=num Glenn ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. Re: Sorting Problems ( Toby Cox 2004)
  2. Re: Sorting Problems ( Brian Fries 2004)
  3. Re: Sorting Problems ( Glenn Busbin 2004)
  4. Re: Sorting Problems ( Pat Holliday 2004)
  5. Re: Sorting Problems ( Glenn Busbin 2004)
  6. Re: Sorting Problems ( Brian Fries 2004)
  7. Re: Sorting Problems ( Joe D'Andrea 2004)
  8. Re: Sorting Problems ( Gary Krockover 2004)
  9. Sorting Problems ( Pat Holliday 2004)
  10. Re: Sorting problems (Kenneth Grome 2000)
> > >5th Jansome data 1 >6th Jansome data 2 >10th Jansome data 3 > >To restrict my search to max=10 is easy and sort latest first > >RecordDatesort=1&RecordDatesdir=de > >is fine but the results come out "upside down": > >10th Jansome data 3 >6th Jansome data 2 > These are not dates as far as WC is concerned. They're text and are sorted as such. You'll need to revise the db to have some other field on which to sort and tell WC what type of data is in that field. One way would be to add a field to each record in the db that contains a number for each day of the year. DayNumRecordDate 11st Jan 22nd Jan .. .. .. 1010th Jan etc. You could then sort using DayNumsort=1&DayNumsdir=de&DayNumtype=num Glenn ------------------------------------------------------------- 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Glenn Busbin

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:

WebCat2b15MacPlugin - showing [math] (1997) cookies and [returnraw] (1997) WebCat2b12plugin - [search] is broken ... not! (1997) WC 2.0 frames feature (1997) [date format] w/in sendmail (1997) WebCat2: multiple currency support (1997) Triggers (1999) [WriteFile] problems (1997) includes and cart numbers (1997) Hosting Services (1999) multi-paragraph fields (1997) Email Problem (1997) [WebDNA] Gulf Coast WebDNA programmers (2010) Fun with dates (1997) [OT] Disable/enable field (2003) database visibility (2000) [WebDNA] WebDNA Showcase? (2008) sorry (1997) test mail (2004) hidden (phantom) file downloads (2000)