reversing records

This is a discussion on "reversing records" within the Classic ASP section. This forum, and the thread "reversing records are both part of the Program Your Website category.


 Subscribe in a reader

Go Back   Webforumz.com > Main Forums > Program Your Website > Classic ASP

Notices




Closed Thread
 
LinkBack Thread Tools
  #1  
Old Sep 4th, 2004, 13:37
benbacardi's Avatar
Highly Reputable Member
Join Date: Feb 2004
Location: United Kingdom
Age: 20
Posts: 611
Thanks: 0
Thanked 0 Times in 0 Posts
reversing records

how can i reverse the output of records in an access database using ASP so that the latest entry is at the top?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!

  #2  
Old Sep 4th, 2004, 14:05
Rob's Avatar
Rob Rob is offline
Webforumz Founder
Join Date: Jul 2003
Location: Southern UK
Age: 34
Posts: 3,189
Blog Entries: 7
Thanks: 27
Thanked 23 Times in 20 Posts
In your SQL query, use the following at the end:-
ORDER BY IDField DESC
__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
  #3  
Old Sep 4th, 2004, 16:59
Highly Reputable Member
Join Date: Aug 2003
Location: Australia
Posts: 662
Thanks: 0
Thanked 0 Times in 0 Posts
or you could always use something like this...
Code: Select all
recordSet.MoveLast
Do While NOT recordSet.BOF
blah blah blah
reocordSet.MovePrevious
Thats the ASP way, but the SQL way is much shorter
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Closed Thread

Tags
reversing, records

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
dns, 'a' records and domain pointing. bmorgan Starting Out 2 Apr 24th, 2008 17:16
Help in displaying records in single row anilreddy76 Databases 0 Sep 18th, 2007 17:53
PHP/MYSQL Displaying records Ydot PHP Forum 6 Jul 23rd, 2007 06:12
Sorting the array - reversing the sequence codes? Ozeona Flash & Multimedia Forum 1 Aug 3rd, 2005 01:52
Random records.. u2orange Databases 6 Mar 8th, 2004 09:31


All times are GMT. The time now is 07:58.


Powered by vBulletin®
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0 RC8
© 2003-2008 Webforumz.com : All Rights Reserved

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42