ODBiC Discussion Board

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


Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


Copyright ©1997-2003, Roger Harris. All rights reserved.