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 Get the mailserver that powers this list at http://www.coolfusion.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
