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
Name E-mail optional TopicMessage:
HTTP Link: Link text: