Try this...
<CFQUERY name="upd_vote_yes" datasource="#datasource#">
update dbo.tbl_contest_2007
SET cb_vote1 = 1
WHERE cbcont_id IN (<cfqueryparam cfsqltype="cf_sql_integer"
value="#FORM.vote#" list="true">)
</CFQUERY>
_____
Jake Churchill
CF Webtools
11204 Davenport, Ste. 200b
Omaha, NE 68154
http://www.cfwebtools.com
402-408-3733 x103
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, July 06, 2007 10:09 AM
To: CF-Talk
Subject: CFQUERY where id = #valuelist(values from form scope)#
All, Within a CFQUERY Valuelist works well when working with the query
scope, but
when I try and pass it the form scope (FORM.variablename) tries to read it
as a query.
What can I use besides valuelist to parse this list?
FORM.vote contains ids... 8,9,12,13,14
<CFQUERY name="upd_vote_yes" datasource="#datasource#">
update dbo.tbl_contest_2007
SET cb_vote1 = 1
WHERE cbcont_id IN '#FORM.vote#'>
</CFQUERY>
Thanks
D
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Upgrade to Adobe ColdFusion MX7
The most significant release in over 10 years. Upgrade & see new features.
http://www.adobe.com/products/coldfusion?sdid=RVJR
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283067
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
