Try a preserve single quote only on the value of the specific field where the single quote is contained, it looks like you are doing it on the entire SQL Query.
Alex Santantonio Lead Developer Macromedia Coldfusion 5 Certified Professional Macromedia Certified Web Site Developer [EMAIL PROTECTED] www.doceus.com -----Original Message----- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 11:29 AM To: CF-Talk Subject: SQL 2k any idea why ' would kill the posting even when i have tried it both with preservesinglespace and without ;) Thanks its a real pain in my arse DBC Error Code = 37000 (Syntax error or access violation) [MERANT][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string 'DATABASE ERROR: Type: DATABASE Message: ODBC Error Code = 37000 (Syntax error or access violation) Detail: [MERANT][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string 'I would like to apply for pilot position in a U.S.A. Aircargo or Transport.I flew B737-200 PIC, DC9 PIC... SQL = "insert into errortracking(errordate,errormessage) values('2001-10-26 11:10:17','DATABASE ERROR: Type: DATABASE Message: ODBC Error Code = 37000 (Syntax error or access violation) Detail: [MERANT][ODBC SQL Server Driver][SQL Server]Unclosed quotation mark before the character string ''I would like to apply for pilot position in a U.S.A. Aircargo or Transport.I flew B737-200 PIC, DC9 PIC, BAC 1-11 PIC, MD83-80 SIC, B747 SIC, CL44 SIC. I flew Argentina domestics, Brasil, Uruguay, Chile, Bolivia, USA, Europe. At the present I''. SQL = "update member SET dob=''03/06/1954'', dateavailable=''10/26/2001'' ,lastname=''Garcia'' ,firstname=''Augusto'' ,middlename=''Cardone'' ,securityquestion=''Whats lapa pin?'' ,securityanswer=''8410'' ,passportnumber=''10962788n'' ,passportexpdate=''06/05/2003'' ,address=''Rivadavia 46 p12B -San Isidro'' ,address1='''' ,city=''Pcia Bs As'' ,state=''-N/A-'' ,province=''-Pcia Bs As'' ,zip=''1642'' ,ssn='''' ,citizen=''Argentinia'' ,country=''Argentinia'' ,righttowork=''Argentinia'' ,homephone=''5411-4742-4483'' ,businessphone='''' ,fax='''' ,email=''[EMAIL PROTECTED]'' ,position=''Pilot'' ,exp1=''26'' ,position2='''' ,exp2=''23'' ,position3='''' ,exp3='''' ,objective=''I would like to apply for pilot position in a U.S.A. Aircargo or Transport.I flew B737-200 PIC, DC9 PIC, BAC 1-11 PIC, MD83-80 SIC, B747 SIC, CL44 SIC. I flew Argentina domestics, Brasil, Uruguay, Chile, Bolivia, USA, Europe. At the present I�m flying domestics in Argentina B737-200 as Captain. Total time 12,204hs.// 6,361hsPIC// 5,843hsSIC// I�m 47 years old, married, two son. I offer a well experienced Airline Captain, healthy and loyal.'' ,additionalinfo=''I was ground instructor for emergencies and Flight Instructor. I like outdoor sports, bicicling and sailing.'' ,willingtorelocate=''Y'' ,race=''HI'' ,sex=''M'' ,driverlicense=''argentina 10962788'' ,dlstate=''-N/A-'' ,dlexpire=''12/01/2006'' ,dlsuspend=''Y'' ,english=''Y'' ,french='''' ,russian='''' ,japanese='''' ,spanish=''Y'' ,german='''' ,chinese='''' ,otherlang='''' ,travelatexpense=''Y'' ,preemployment=''Y'' ,convictmisd=''N'' ,convictfelony=''N'' ,lastupdatedby=''1239459dahele'' ,dateupdated=''2001-10-26 11:10:17'' ,lefteyewoglass=''18/20'' ,lefteyewglass=''20/20'' ,righteyewoglass=''18/20'' ,righteyewglass=''20/20'' ,willpay='''' ,willpayifdeducted='''' where membernumber=1235886" Bill Wheatley Director of Development Certified Advanced ColdFusion 5 Developer AEPS INC Allaire ColdFusion Consulting Partner www.aeps.com www.aeps2000.com 954-472-6684 X303 ICQ: 417645 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
