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
