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

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)#

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)#

Try this... update dbo.tbl_contest_2007 SET cb_vote1 = 1 WHERE cbcont_id IN () _ 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:

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

Use cfqueryparam update dbo.tbl_contest_2007 SET cb_vote1 = 1 WHERE cbcont_id IN Marius Milosav ScorpioSoft Corp. www.scorpiosoft.com It's not about technology, it's about people -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: July 6, 2007 11:09 AM To: CF-

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

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)#

Use () instead of the '' and the query should work fine. -Aaron update dbo.tbl_contest_2007 SET cb_vote1 = 1 WHERE cbcont_id IN (#FORM.vote#)> -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, July 06, 2007 11:09 AM To: CF-Talk Subject: CFQUERY where i