You may want to consider using CFQUERYPARAM to avoid SQL injection attacks.
Ray Thompson Tau Beta Pi Headquarters 865-546-4578 www.tbp.org -----Original Message----- From: Scott Williams [mailto:myscottwilli...@yahoo.com] Sent: Friday, March 04, 2011 12:21 PM To: sql Subject: Re: SQL Update Question Never mind -- I figured it out. This worked: <cfquery name="query2" datasource="#dsn#"> UPDATE aTable SET ColumnA = '#form.var1#' WHERE ColumnB IN (#form.var2#) </cfquery> I had tried using IN in my update query except that I didn't include the parentheses. Scott ----- Original Message ---- From: Scott Williams <myscottwilli...@yahoo.com> To: sql <sql@houseoffusion.com> Sent: Fri, March 4, 2011 9:03:02 AM Subject: Re: SQL Update Question cut & paste error Using an Access database on an IIS server Scott ----- Original Message ---- From: Claude Schnéegan <schneegans@interneti=71?=> To: sql <sql@houseoffusion.com> Sent: Fri, March 4, 2011 6:00:27 AM Subject: Re: SQL Update Question >>WHERE WishlistID IN (13,15,74,87) </cfquery Is the missing closing > in </cfquery just a cut'n paste error, or is it the cause of your problem? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3395 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
