You could convert the single quotes in the string to ASCII or PreserveSingleQuotes() might work (been awhile so I'm not 100% sure on the preserve)
Bryan Stevenson B.Comm. VP & Director of E-Commerce Development Electric Edge Systems Group Inc. t. 250.920.8830 e. [EMAIL PROTECTED] --------------------------------------------------------- Macromedia Associate Partner www.macromedia.com --------------------------------------------------------- Vancouver Island ColdFusion Users Group Founder & Director www.cfug-vancouverisland.com ----- Original Message ----- From: "Chris Edwards" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, February 26, 2003 8:19 AM Subject: query problem > Hi > > I've done this a 1000000 times, but now I have a problem....... > > I'm trying to escape the single quote > > why am I getting this: > ODBC Error Code = 37000 (Syntax error or access violation) > > > [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in > query expression ''testing\'s', '', '', '', '', '', '', '', '02/26/2003' )'. > > > SQL = "INSERT INTO JobListings ( position, reportsto, eduexp, jobknow, > skillsabil, workcond, posiavail, deadline, created ) VALUES( 'testing\'s', > '', '', '', '', '', '', '', '02/26/2003' )" > > -- > Chris Edwards > Web Application Developer > Outer Banks Internet, Inc. > 252-441-6698 > [EMAIL PROTECTED] > http://www.OuterBanksInternet.com > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
