Use <cfqueryparam> then you won't have to worry about it anymore. ============================================ Bryan F. Hogan Director of Internet Development Macromedia Certified ColdFusion MX Developer Digital Bay Media, Inc. 1-877-72DIGITAL ============================================
-----Original Message----- From: Chris Edwards [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 26, 2003 11:19 AM To: CF-Talk 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
