It looks like you have to do StructNew within the loop for every iteration.
In your code you are only doing that once, for the first array element.
----- Original Message -----
From: "Darren Adams" <[EMAIL PROTECTED]>
<!--- 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>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
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
