hey all,

i'm pretty new at asp and databases, so i'm having trouble with advanced sorting. I'm using dreamweaver csIII, VBScript, and an access db. i have a left navigation column with 10 links that when clicked bring in information from the database. i then have five category's that i want users to be able to sort by once the information is displayed. i know this may be rather routine, so any help or direction to tutorials would be much appreciated. thanks.

this is how I would to it...

<pre id=code><font face=courier size=2 id=code>
&lt;%
' ::::: THIS EXAMPLE ASSUMES SEVERAL THINGS...
' ::::: 1. YOU ARE PASSING FORM DATA TO THIS PAGE USING A
' ::::: VARIABLE NAMED 'SORT_ORDER'.
' :::::
' ::::: 2. THAT THE POSSIBLE VALUES THAT MAY BE SUBMITTED
' ::::: ARE '1', '2', '3', AND '4'.
' :::::
' ::::: 3. THAT YOU WANT THE DEFAULT SORT ORDER IF A VARIABLE
' ::::: IS *NOT* PASSED OR AN UNSPECIFIED VARIABLE IS PASSED
' ::::: TO BE BY LAST NAME IN ASCENDING ORDER (THE CASE ELSE
' ::::: STATEMENT).

select case request.form("sort_order"

' ::::: COMMENT OUT THE LINE ABOVE AND UNCOMMENT THE LINE BELOW
' ::::: IF YOU ARE USING THE GET METHOD INSTEAD OF POST

' select case request.querystring("sort_order"
case "1"
var_sort = "ORDER BY id ASC"
case "2"
var_sort = "ORDER BY id DESC"
case "3"
var_sort = "ORDER BY name_first ASC"
case "4"
var_sort = "ORDER BY name_first DESC"
case else
var_sort = "ORDER BY name_last ASC"
end select

Set rs_tutorial_cmd = Server.CreateObject ("ADODB.Command"
rs_tutorial_cmd.ActiveConnection = cs_my_connection_string
rs_tutorial_cmd.CommandText = "SELECT * FROM my_table " & var_sort
Set rs_tutorial = rs_tutorial_cmd.Execute
var_sort = ""

%&gt;

Hope this helps...
</font id=code></pre id=code>

- Doc

Progress is made by the discontent.

Edited by - daveblohm on 02 Aug 2007 18:07:07

thanks dave blohm

opps...made a mistake...left out ORDER BY within the select statement...see above.

- Doc

Progress is made by the discontent.