Sorting Problems

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 55454
interpreted = N
texte = Hi, I have records stored in a db that each have a date chosen by the user - [RecordDate]. (I.e. the records all have a date but they are not necessarily in the Db in date order - so rank=off won't work.) By default a user will view a page of records loaded with the [RecordDate] most recent 10, although they can choose to view 20, 50 or all matching records. The nature of the site requires that records appear on the page horizontally, earliest first. eg: 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 etc Anyone think of an elegant solution to this problem? Thanks Pat ps something like this has been mentioned, seems a bit processor intensive tho: [search db=patsrecords.db&eqcriteriadata=[criteria]&RecordDatesort=1&RecordDates dir=as] [text]OnlyShowIndex=[math][numfound]-[MaxRecords][/math][/text] [founditems] [hideif [index]<[OnlyShowIndex]] Whatever [/hideif] [/founditems] [/search] ....or sumfin...:) --------------------------------------------------------- Netro42 - http://www.netro42.com Web design and development --------------------------------------------------------- Netro42 Limited 39 - 51 Highgate Road London NW5 1RT T: 020 7267 7002 F: 020 7267 7544 E: mailto:patrick.holliday@netro42.com --------------------------------------------------------- ------------------------------------------------------------- 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)
Hi, I have records stored in a db that each have a date chosen by the user - [RecordDate]. (I.e. the records all have a date but they are not necessarily in the Db in date order - so rank=off won't work.) By default a user will view a page of records loaded with the [RecordDate] most recent 10, although they can choose to view 20, 50 or all matching records. The nature of the site requires that records appear on the page horizontally, earliest first. eg: 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 etc Anyone think of an elegant solution to this problem? Thanks Pat ps something like this has been mentioned, seems a bit processor intensive tho: [search db=patsrecords.db&eqcriteriadata=[criteria]&RecordDatesort=1&RecordDates dir=as] [text]OnlyShowIndex=[math][numfound]-[MaxRecords][/math][/text] [founditems] [hideif [index]<[OnlyShowIndex]] Whatever [/hideif] [/founditems] [/search] ....or sumfin...:) --------------------------------------------------------- Netro42 - http://www.netro42.com Web design and development --------------------------------------------------------- Netro42 Limited 39 - 51 Highgate Road London NW5 1RT T: 020 7267 7002 F: 020 7267 7544 E: mailto:patrick.holliday@netro42.com --------------------------------------------------------- ------------------------------------------------------------- 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/ Pat Holliday

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:

off topic fetch vs PCS photomaster (1997) Looking up two prices in Formulas.db (1997) WebCatalog Hosting (1996) WebDNA emailer details (2005) WebCat b13 CGI -shownext- (1997) WebDNA 5 & iTools 7 (2003) LIstFiles - filnames are cart numbers. (2000) WebCat2 - Getting to the browser's username/password data (1997) switching users (1998) 2nd WebCatalog2 Feature Request (1996) WebCat2b13MacPlugIn - [showif][search][/showif] (1997) [GROUPS] followup (1997) [OT] - HTTP_REFERER (2004) Browser Info.txt (1997) WebCat2b12 CGI Mac - [shownext] problem (1997) [username][password] not showing up! HELP! (1999) Problems with ^ could be solved with [REPLACE CHARACTERS] (1997) best way to get 2 unique strings on the same page load? (2000) Displaying raw values (long) (1998) Separate SSL Server (1997)