Signup · Login
Stardeveloper.com  
Home · Tutorials · Forums · ASP.NET Newsletter Application · Web Hosting Plans · Faisal Khan's Blog · Contact
Forums : ASP : ADO/ODBC : Shorting? Signup · Login
Author Thread
Shorting?
Posted in tutorial: Using ASP pages to page through Recordsets
·  MadDog
User
Joined: 25 Nov 2002
Total Posts: 1

Shorting?

Posted: 25 Nov 2002
Is it possible to short the files with this? Like setting it to short by created date or by file name??

Thanks in advanced!

p.s. This site has helped me with allot of stuff, thanks allot!
·  Faisal Khan
AdminAdminAdminAdmin
Joined: 24 Sep 2002
Total Posts: 595
Re: Sorting
Posted: 26 Nov 2002
You can filter and sort the records as you want using the Recordset object. Just use rs.Filter and rs.Sort properties ( whichever you need ).

For example, add following two lines below rs.Open line in this article example ( 'paging.asp' ) code to see the results getting sorted and filtered:


rs.Filter = "id > 10"
rs.Sort = "first_name"

The rs.Sort property should be a set to one or more comma separated column-names for records to get sorted on.

Enjoy.

Faisal Khan.
Stardeveloper.com
Read Blog | Follow on Facebook, Twitter
Want to leave a comment? Login or Register for free!

Users Who Have Visited This Thread In Last 24 Hours
2 Visitors

Login to post a comment or start a new thread
UserName Or Email Address:       Password:       Auto-Login:    
· Create New User Account
· Send Forgotten Password by Email
 
© 1999 - 2010 Stardeveloper.com, All Rights Reserved.