It should work anywhere external values are added to theSQL, inserts and updates included
b -----Original Message----- From: Jason Bayly [mailto:[EMAIL PROTECTED] Sent: Wednesday, 24 March 2004 9:33 AM 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 [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
