RE: Sorting data in OPTIONLIST command, Scott, 04-20-2005
Need to check for any SQL error, but...
by Roger Harris, April 20, 2005 13:06
(Your posting has "ORBER" instead of "ORDER", but they may be a typo just in your posting.) Temporarily add a line to your script to display $sql_error$ immediately after the OPTIONLIST command. If you are getting an SQL execution or syntax error, that variable will have the ODBC error message text.
But you shouldn't really need to order by the same column that you are selecting -- that should be automatic (i.e. the command should have added "ORDER BY toolnumber" to the generated SQL. If you display $sql_statement$ after the OPTIONLIST, you will see the SQL that was executed.)
Name E-mail optional TopicMessage:
HTTP Link: Link text: