ODBiC Discussion Board

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.)


Post Your Reply:

E-mail  optional

HTTP Link: 
Link text: 


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