...this 'should' work
<cfquery datasource="test_data" name="cat_name">
SELECT category, category_no
FROM job_categories
Where category_no IN ( <cfqueryparam cfsqltype="CF_SQL_VARCHAR" list="Yes" value="#form.category2#" /> )
</cfquery>
Doug
-----Original Message-----
From: Tim Laureska [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 08, 2003 12:43 PM
To: CF-Talk
Subject: query output question
This is probably basic, but I've not run into it before... I have the
following select area in a form:
<select name="category2" size=3 multiple>
<option value="10">Accounting/Auditing</option>
<option value="20">Agriculture, Forestry, Fishing</option>
<option value="30">Architecture & Engineering</option>
<option value="40">Arts & Entertainment</option>
<option value="50">Administrative/Clerical</option>
</select>
When I submit multiple selects to the next page, I attempt to match up
the category2 values (ie 10, 20 etc) using the following query
<cfquery datasource="test_data" name="cat_name">
SELECT category, category_no
FROM job_categories
Where category_no=#category2#
</cfquery>
but I get the following error, that I can't figure out how to get
around:
ODBC Error Code = 37000 (Syntax error or access violation)
[Microsoft][ODBC Microsoft Access Driver] Syntax error (comma) in query
_expression_ 'category_no=10,30'.
_____
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
