Requery & Sort ADO Recordseat

[rparsons]

I am trying to sort an ADO recordset by using a button click event but it will not seem to work. The table based on the recordset works fine but know I want to sort the columns based on the user clicking a button. I know it has something to do with my syntax but I don't know coding all that well. Any help would be appreciated.

Here is the onclick

<INPUT TYPE=BUTTON VALUE="Sort By Workstation" onclick="<% rsSort=WorkstationID & rs.Requery adExecuteRecord %>”

[rparsons]

Oh well, had to try. I went ahead and used your second suggestion. Worked great, thanks. I am trying to eliminate a second trip to the SQL server and have decided to give it a go the XML way using data islands. Thanks again.

[rparsons]

I like the sorting asc and desc. That works real well. I will have to look into the JAVA array method when I get time.