Some suggestions: 1) Try cfoutput instead of cfquery so you can see what the generated SQL looks like.
2) Is response an integer data type? If so you don't want the quotes. 3) Try using cfquyeryparam. It makes things like this much easier. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- > [EMAIL PROTECTED] On Behalf Of Jason Bayly > Sent: Wednesday, 24 March 2004 11:11 a.m. > To: CFAussie Mailing List > Subject: [cfaussie] Single quote issue > > 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 leave-cfaussie- > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 --- 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
