This is a discussion on "printing out a record set backwards" within the Classic ASP section. This forum, and the thread "printing out a record set backwards are both part of the Program Your Website category.
|
|
|
|
|
![]() |
||
printing out a record set backwards
|
||
| Notices |
![]() |
|
|
LinkBack | Thread Tools |
|
#1
|
|||
|
|||
|
printing out a record set backwards
let's say that i have 4 elements in the record set. but instead of printing them out in order i want to go backwards like so..
4 3 2 1 how would one accomplish this? I've tried moving to the 4th element and using the moveprevious command but that doesn't seem to work. any help? thanks. |
|
|
|
#2
|
||||
|
||||
|
Re: printing out a record set backwards
you would need to use
rs.movelast for myloop = rs.recordcount to 1 step -1 'do something rs.moveprevious next .... or something very similar.
__________________
Click the 'Thanks!' button if this post has helped you Rob - Webforumz Founder
Last Blog Entry: Creative Labs threaten developer over home made drivers.... (Apr 1st, 2008)
|
|
#3
|
|||
|
|||
|
You can do as Rob said, but bad form in my opinion. Better to put a proper ORDER BY in your SQL.
|
|
#4
|
|||
|
|||
|
Re: printing out a record set backwards
yeah, i ended up just ordering them by DESC in my sql statement. thanks for the help though.
|
|
#5
|
||||
|
||||
|
Re: printing out a record set backwards
Lol...... I could hit myself.
__________________
Click the 'Thanks!' button if this post has helped you Rob - Webforumz Founder
Last Blog Entry: Creative Labs threaten developer over home made drivers.... (Apr 1st, 2008)
|
![]() |
| Tags |
| printing, record, set, backwards |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Printing | Jack Franklin | Webforumz Cafe | 5 | Jun 13th, 2008 12:04 |
| [SOLVED] Reading as text file backwards | eon201 | PHP Forum | 4 | Nov 8th, 2007 10:53 |
| Printing single record from Access via Report in Web Page | Neotekk | JavaScript Forum | 0 | Jun 18th, 2007 15:20 |
| backwards script | ST | JavaScript Forum | 3 | Jan 12th, 2006 21:37 |
| printing | spinal007 | Web Page Design | 2 | Nov 17th, 2004 13:37 |