Thanks peoples yeah cfqueryparam works a treat... in 4 or so years ive never had to use it before,,, one has to wonder sometimes.. LOL
UPDATE TBL_Poll_Responses SET Response = <cfqueryparam cfsqltype="cf_sql_varchar" value="#EVALUATE(TRIM(VCurResponse))#"> WHERE response_id = #EVALUATE(VCurPK)# works a treat... Cheers "Jason Bayly" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > > Hi Guys/Gals, > > For some reason my inserts are failing due to single quotes. I though CF > automatically escaped them in SQL statements. > > UPDATE TBL_Poll_Responses > SET Response = '#EVALUATE(TRIM(VCurResponse))#' > WHERE response_id = #EVALUATE(VCurPK)# > > I need to set my vars dyanmically as im building a quiz app (with many > variables), so i need to use the evaluate the function.. Would this be > causing my DB errors? (Line 2: Incorrect syntax near '2'.) etc.. > > Any thoughts? > > Jason > > > > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
