Can anyone lend me a hand ?
I am trying to store one database in an array of structures then insert it
into another database.
I am only using one field at the moment but, there will be 9 that I want to
copy over.
What I am trying to do is to take PressReleaseHeader from the
pressreleasetable.
But it keep giving me errors.
<!--- query the old newsroom database--->
<cfquery name="news" datasource="newsadmin" dbtype="ODBC">
select * from pressreleasetable
ORDER by pressreleasedate DESC
</cfquery>
<!---Setup an array with a structure --->
<cfset oldnews = ArrayNew()>
<cfset oldnews[1] = StructNew()>
<!---add others here later e.g. prsub,prcontent,date etc... --->
<Cfoutput query="news">
<cfset oldnews[news.currentrow].headline = #pressreleaseheader#>
</cfoutput>
Darren Adams
Web Developer
Marketing Department
Systems Union
Office: 01252 55 6220
Mobile: 07714 817 038
Email: [EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
