Whats the best script to remove and replace special characters that will
make sql2000k error out
thxw!
[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 'CORPORATE CHALLENGER PILOTS A major
corporate operator seeks to appoint two captains and a copilot to ...
SQL = "insert into errortracking(errordate,errormessage)
values('2001-09-24 15:48:16','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 ''CORPORATE CHALLENGER PILOTS A major
corporate operator seeks to appoint two captains and a copilot to be
based in Melbourne Australia One of the captain positions will have the
responsibility of Senior Pilot The successful applicants will be
expected to operate the corporate aircraft in the capacity of aircraft
captain and copilot In additi...
SQL = "Insert into
job(jobid,creationdate,createdby,companyid,password,
jobtitle,companyname,contactname,address,city,state,zip,country,phone,fax
,province, email, active,datecancelled,description,position,status,
specificposition,relocation,salarymin,salarymax,areaofcountry,
willingtoworkshifts,jobstate,jobcountry,jobcitizen,jobrighttowork,jobtype
ofcompany,
jobarea,jobcountries,jobrace,jobsex,jobaircraft,jobrated,jobminhoursinair
craft,
mintotalhours,minmrecphours,minmtjethours,mintprphours,maxtotalhours,jobp
hysicalclass,
minhelihours,minpichours,minfehours,mintihours,jobprivs,jobhs,jobtradesch
ool,
job2college,job4college,job4collegemajor,jobgraddegree,jobgradmajor,jobfe
written,
jobatpwritten,jobmilitarytrained,jobpriorexp,jobpayinterviewcosts,jobprof
iletest,
jobpayfortrainingifjob,willingtopayifdeducted,jobminage,jobmaxage,currenc
y,jobfccclass1,
jobfccclass2,jobfccclass3,jobdirofmaint,jobdirofmaintmonths,jobqualitycon
trol,
jobqualitycontrolmonths,jobmaintsuper,jobmaintsupermonths,jobdar,jobdarmo
nths,
jobder,jobdermonths,jobhelimaint,jobhelimaintmonths,jobmonthslinemaint,
jobmonthslinemaintaircraft,jobmonthsaircraftoh,jobmonthsaircraftohaircraf
t,
jobmonthengineoh,jobmonthengineohengine,jobmonthsaccessoriesoh,jobmonthsa
ccessoriesohaccess,jobmonthsmanufacturing,jobmonthsmanufacturingaircraft,
jobpublicexp,jobenglish,jobrussian,
jobspanish,jobfrench,jobjapanese,jobchinese,jobgerman,jobother,jobminweig
ht,jobmaxweight,
jobminheight,jobmaxheight,joblefteyewoglass,jobrighteyewoglass,joblefteye
wglass,jobrighteyewglass,jobcorrectedwglass,jobcorrectedwoglass,jobinflig
htmanager,jobcorpfaexp,
jobchieffltatt,jobfainst,jobdiroftrainingfa,joblinecheck,joblicensedispat
ch,jobyearsdomexp,
jobyearsinternationalexp,jobewins,jobetops,jobflightcontrol,jobtypeofexpe
rience,
jobwantexpareasus,jobwantexpareas,jobtraineddispatcher,jobsuperviseddispa
tcher,
jobmilitarydispatcher,jobassistantdispatcher,jobdispatchprivs,custom,emai
ljob,internaljobid)
values(1246752,''2001-09-24'',''WEBUSER'',19930,''PASSWORD'', '' '',
''Advanced Aircraft Electronics'', ''Bill Caldwell'', ''1845 N. Marshall
Ave'', ''El Cajon'', ''CA'', ''92020-1122'', ''USA'', ''619-449-4037'',
''619-449-6394'', '' '', '' '', ''Y'', ''10/24/01'',''CORPORATE
CHALLENGER PILOTS A major corporate operator seeks to appoint two
captains and a copilot to be based in Melbourne Australia One of the
captain positions will have the responsibility of Senior Pilot The
successful applicants will be expected to operate the corporate aircraft
in the capacity of aircraft captain and copilot In addition to normal
flight duties the pilots will be expected to assist the Senior Pilot in
coordinating training licensing and rostering of flight and cabin
crew flight despatch and management of flight safety The successful
candidates will have right of residency in Australia and hold a valid
Australian ATPL Preference will be given to applicants with a CL604
command type rating and 100 hours in command on type In addition
applicants will meet or exceed the following 3000 hours total time 2500
hours in command 1500 hours in aircraft above 5700 kg MTOW 500 hours in
command of multi engine aircraft 500 hours in command of turbine
aircraft Extensive international experience in the corporate aviation
environment Applicants must have good communication and representational
skills with exposure to VIP passengers and be able to work effectively
as part of a small team The nature of corporate aviation is such that
individuals will be expected to manage all administrative aspects
associated with international operations The incumbents must have sound
knowledge of Australian Civil Aviation Regulations and international
aviation standards The successful candidates will fly extensively
internationally and must therefore be prepared to be away from home base
frequently and for extended periods of time A highly competitive salary
negotiable according to experience will be offered Applications quoting
reference 16873 to be sent to Robert Martinello By friday 28th september
2001'',''PI'' ,''active'', ''SIMULATOR INSTRUCTOR'', '''', 0, 0, '''',
'''', '''', '''', '''', '''', '''', '''', '''', '''', '''', '''', '''',
0, 0, 0, 0, 0, 0, '''', 0, 0, 0, 0, '''', '''', '''', '''', '''', '''',
'''', '''', '''', '''', '''', '''', '''', '''', '''', '''', '''', '''',
'''', '''', '''', '''', '''', '''', '''', '''', '''', '''', '''', '''',
'''', '''', '''', '''', '''', '''', '''', '''', '''', '''', '''', '''',
'''', '''', '''', '''', '''', '''', '''', '''', '''', '''', '''', 0, 0,
0, 0, '''', '''', '''', '''', '''', '''', '''', '''', '''', '''', '''',
'''', '''', 0, 0, '''', '''', '''', '''', '''', '''', '''', '''', '''',
'''', '''', ''N'',''N'', '''' )"
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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists