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
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
:[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
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
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
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
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
7 matches
Mail list logo