Sort select box classic asp

Question

I have a select box which is loaded from the database. I can't change nothing in the database, so i need to sort (from A to Z) the select box in the client side. I can use ither vbscript or javascript.

Thanks.

Answer 1

Here's a previously answered Stack Overflow question that sorts a select box using Javascript: Javascript to sort contents of select element

Answer 2

You can sort the recordset on the page after you get the data from the database.

Try using...

rs.Sort="FieldName"

and the data will be resorted.