try replacing all single quotes with two. ~Simon
Simon Horwith Macromedia Certified Instructor Certified Advanced ColdFusion 5 Developer Fig Leaf Software 1400 16th St NW, # 500 Washington DC 20036 202.797.6570 (direct line) www.figleaf.com -----Original Message----- From: William J Wheatley [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 12:17 PM To: CF-Talk Subject: Re: SQL 2k nah just on the one i saw but i see CFQUERYPARAM i hear might be promising 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 ----- Original Message ----- From: "Alex Santantonio" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Friday, October 26, 2001 11:43 AM Subject: RE: SQL 2k > 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 > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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 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
