Darren,
I have a few questions / comments.
1) Why do you convert the query, which is conceptually a structure of
arrays into an array of structures?
2) Why don't you insert the records into the data base in one step? e.g.
<cfquery>
insert into pressoffice
(headline,subtitle,body,date,expdate,country,live,author)
select headline, subtitle, body,date,expdate,country,live,author
from pressrelesetable where live =1
</cfquery>
3) Try using SQL comments "--" in your query instead of Cold Fusion
comments.
--
Josh Meekhof
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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