How do i sort the resultset 1

[Natraj]

Hi<br>
I am displaying the resultset on my browser, now i want to use a method by which, when the user click on the column heading the data is sorted on that column. Can anyone suggest a method to do this using VBScript.<br>
PS:Its urgent, need to complete a project.<br>
Natraj

 

[ronwilli]

The best way that I know of to do this is to use the ORDER BY clause in your SQL.

Try something like this....

<% 'build sql statement
strSQL = &quot;Select .... From .... Where ....&quot;

'check for a sort field in the Request.Querystring object
If Request.Querystring(&quot;sortby&quot <> &quot;&quot; then
strSQL = strSQL & &quot; Order by &quot; & _
Request.Querystring(&quot;sortby&quot
End If

'open you recordset as usual
%>

As you build your page, when it comes to creating the
column headers, place links in them to reload the page with
the correct sortby field passes as a parameter.

Ex: <a href=&quot;asppage.asp?sortby=<your field name>&quot;>Field Name</a>

If you are using buttons or whatever instead of links in a table, you could do that on the onclick event.

Now when the user clicks on the field, you will pass the sortby field to the page which will then use the ORDER BY to sort your recordset.

Hope that helps...Ron

 

[link9]

The ADO Recordset also has a .sort method, which you can read up on at

http://www.devguru.com/Technologies/ado/quickref/recordset_sort.html

Not the most efficient way of the two, but it has it's uses from time to time.