10/27/2007 4:42:48 AM
RE:SQL Statement Drop Down List
Your SQL Statement needs to return results in name/value pairs. I.e. your statement will need to select two columns one that will be used for the selected text (the name) and one that will be used for the selected value. And there is nothing saying that you couldn't return the same column for both, but you do need to repeat the column.
-- Simple Example
SELECT Code, Display FROM MyCodeTable
-- Using the same column for both display and value
SELECT Code as Value, Code as Name FROM MyCodeTable