How about:
<CFQUERY name="upd_vote_yes" datasource="#datasource#">
update dbo.tbl_contest_2007
SET cb_vote1 = 1
WHERE cbcont_id IN (#ListQualify(Form.Vote,"'")#)>
</CFQUERY>
Cheers,
Chris
[EMAIL PROTECTED] wrote:
> 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
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Macromedia ColdFusion MX7
Upgrade to MX7 & experience time-saving features, more productivity.
http://www.adobe.com/products/coldfusion?sdid=RVJW
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:283076
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
