Re: CFQUERY where id = #valuelist(values from form scope)#

CFQUERY name=upd_vote_yes datasource=#datasource# update dbo.tbl_contest_2007 SET cb_vote1 = 1 WHERE cbcont_id IN ('#Replace(FORM.vote,',',',','all)#') /CFQUERY Basically, each item in the list needs to be wrapped in single quotes. Dominic On 06/07/07, [EMAIL PROTECTED] [EMAIL

RE: CFQUERY where id = #valuelist(values from form scope)#

Use () instead of the '' and the query should work fine. -Aaron CFQUERY name=upd_vote_yes datasource=#datasource# update dbo.tbl_contest_2007 SET cb_vote1 = 1 WHERE cbcont_id IN (#FORM.vote#) /CFQUERY -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday,

RE: CFQUERY where id = #valuelist(values from form scope)#

Use cfqueryparam CFQUERY name=upd_vote_yes datasource=#datasource# update dbo.tbl_contest_2007 SET cb_vote1 = 1 WHERE cbcont_id IN cfqueryparam cfsqltype=cf_sql_int list=yes value=#FORM.vote# /CFQUERY Marius Milosav ScorpioSoft Corp. www.scorpiosoft.com It's not about technology, it's about

RE: CFQUERY where id = #valuelist(values from form scope)#

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

Re: CFQUERY where id = #valuelist(values from form scope)#

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

Re: CFQUERY where id = #valuelist(values from form scope)#

use cfqueryparam CFQUERY name=upd_vote_yes datasource=#datasource# update dbo.tbl_contest_2007 SET cb_vote1 = 1 WHERE cbcont_id IN (cfqueryparam value=#FORM.vote# list=yes cfsqltype=cf_sql_integer) /CFQUERY J.J. On 7/6/07, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: All, Within a CFQUERY