Sorting data in OPTIONLIST command

by Scott, April 20, 2005 09:44

Hi all,

I am using the option list comamnd:

<% OPTIONLIST toolnumber from toolnumber %>

and it works fine except it lists all the values in the order they are in the database. would like them displayed in a numeric order. All the numbers are entered as numbers and the database is defined as a text field.

I tried: <% OPTIONLIST toolnumber from toolnumber ORBER BY toolnumber DESC %>

but that just caused the error message: [No option list found for toolnumber]

Any ideas?

Thanks, Scott

Replies:

• Need to check for any SQL error, but..., Roger Harris, 04-20-2005
Next | Previous | Top

Post Your Reply:

Name   
E-mail  optional
Topic  

HTTP Link: 
Link text: