Check your last query. You have an extra ) where you list your values
This
'#oldnews[i].expdate#'),
should be this
'#oldnews[i].expdate#',
<cfquery name="newnews" datasource="cosmos1" dbtype="ODBC">
insert into pressoffice
(headline)<!---,subtitle,body,date,expdate),country,live,author--->
Values
('#oldnews[i].headline#')
<!---,'#oldnews[i].subtitle#','#oldnews[i].body#','#oldnews[i].date#',
------------------ RIGHT HERE--------
'#oldnews[i].expdate#'),
------------------------------------------
'#oldnews[i].country#','#oldnews[i].live#','#oldnews[i].author#'--->
</cfquery>
HTH,
Art
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists