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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
