ODBiC Discussion Board


RE: OPTION LIST : I am getting closer...., Scott, 03-09-2005

Not sure why that WHERE clause should be needed

by Roger Harris, March 10, 2005 08:24

Your original OPTIONLIST statement should have generated the SQL statement, "SELECT DISTINCT category FROM swo ORDER BY category". (You can verify the actual statement by displaying the variable $sql_statement$ after the optionlist.) I can't think of any reason why you should need to add that WHERE clause. What database are you using? Please try this test script and see what you get:

<%
DATABASE "...";
SELECT DISTINCT category FROM swo ORDER BY category;
TABLE;
%>

$sql_error$<br> $sql_statement$



Replies:


Post Your Reply:

Name   
E-mail  optional
Topic  
Message:

HTTP Link: 
Link text: 

          


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