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

2007-07-06 Thread J.J. Merrick
use cfqueryparam update dbo.tbl_contest_2007 SET cb_vote1 = 1 WHERE cbcont_id IN () J.J. On 7/6/07, [EMAIL PROTECTED] <[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.variablenam

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

2007-07-06 Thread Christopher Jordan
How about: update dbo.tbl_contest_2007 SET cb_vote1 = 1 WHERE cbcont_id IN (#ListQualify(Form.Vote,"'")#)> 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

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

2007-07-06 Thread Jake Churchill
:[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

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

2007-07-06 Thread Marius Milosav
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

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

2007-07-06 Thread Dominic Watson
update dbo.tbl_contest_2007 SET cb_vote1 = 1 WHERE cbcont_id IN ('#Replace(FORM.vote,',',"','",'all)#') Basically, each item in the list needs to be wrapped in single quotes. Dominic On 06/07/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > All, Within a CFQUERY Valuelist

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

2007-07-06 Thread Aaron Wolfe
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

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

2007-07-06 Thread coldfusion . developer
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 update dbo.tbl_contest_2007