<cfquery> syntax problem

[samb1]

Guys can someone tell me whats wrong with the line I have put in bold? Im
trying to run this query but I get an error telling me the syntax is wrong near
the second insert. Here is my code: <cfquery name='insJobRecord'
datasource='project'> insert into temp (ref, Description, Title, Salary,
Location, Contract, CloseDate, IntDate, CurrentDate) values
(<cfqueryparam value='#Links2#' cfsqltype='CF_SQL_VARCHAR'>,
<cfqueryparam value='#thisJD2#' cfsqltype='CF_SQL_LONGTEXT'>, <cfqueryparam
value='#thisTitle2#' cfsqltype='CF_SQL_VARCHAR'>, <cfqueryparam
value='#thisSalary2#' cfsqltype='CF_SQL_VARCHAR'>, <cfqueryparam
value='#thisLocation2#' cfsqltype='CF_SQL_VARCHAR'>, <cfqueryparam
value='#thisContract2#' cfsqltype='CF_SQL_VARCHAR'>, <cfqueryparam
value='#thisClosDate2#' cfsqltype='CF_SQL_DATE'>, <cfqueryparam
value='#thisIntDate2#' cfsqltype='CF_SQL_VARCHAR'>, <cfqueryparam
value='#now()#'>) insert into job (ref, Description, Title,
Salary, Location, Contract, CloseDate, IntDate, CurrentDate) SELECT
ref,Description,Title,Salary,Location,Contract,Clo seDate,IntDate,CurrentDate
FROM MyTempTable WHERE NOT EXISTS ( SELECT Description
FROM Job WHERE
Replace(Replace(Replace(Replace(SUBSTRING(Job.Desc ription, 1, 5000),'
',''), Chr(9), ''), Chr(10), ''), Chr(13), '') =
Replace(Replace(Replace(Replace(SUBSTRING(Temp.Des cription, 1, 5000),'
',''), Chr(9), ''), Chr(10), ''), Chr(13), '') ) DROP TABLE
MyTempTable </cfquery>TextText

[Kronin555]

You have to break these out into separate cfquery calls. It looks like you're
doing 2 inserts and a table drop in one <cfquery> tag. Also, you don't put
semicolons at the end of your query contained in a <cfquery>