Right. Cfqueryparam should fix that, as Barry said. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:bounce-cfaussie- > [EMAIL PROTECTED] On Behalf Of Jason Bayly > Sent: Wednesday, 24 March 2004 11:33 a.m. > To: CFAussie Mailing List > Subject: [cfaussie] Re: Single quote issue > > > 1) Try cfoutput instead of cfquery so you can see what the generated SQL > > looks like. > > UPDATE TBL_Poll_Responses SET Response = 'test'1' WHERE response_id = 40 > > > 2) Is response an integer data type? If so you don't want the quotes. > its a string > > > 3) Try using cfquyeryparam. It makes things like this much easier. > All the examples for this tag are shown using the tag in the where > clause ? > Is this the only place, or can/should it be used with the values being > inseted i.e. SET Response = 'test'1' (which is where its falling over), > inserting the poll questions and responses.. > > jason > > "Matthew Walker" <[EMAIL PROTECTED]> wrote in message > news:[EMAIL PROTECTED] > > > > 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 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
