I should have explained where I am at. I have run the qury to get the data and
then created and populated the 2darray in a loop. Code shown below.
<cfquery name="GetFundNames" datasource="CPDU_Projects">
SELECT PRJ_PointID, PRJ_MainID, Fund_Name
FROM PRJ_FundAmount
GROUP BY PRJ_PointID, PRJ_MainID, Fund_Name
</cfquery>
<!--- Create an array to hold data from GetFundNames Query --->
<cfset MyArray = ArrayNew(2)>
<!--- Populate the array with the query data --->
<cfloop query="GetFundNames">
<cfset MyArray[currentrow][1][1]=PRJ_PointID[currentrow]>
<cfset MyArray[currentrow][1][2]=PRJ_MainID[currentrow]>
<cfset MyArray[currentrow][1][3]=Fund_Name[currentrow]>
</cfloop>
Now I'm at the point of trying to navigate through the array line by line.
I want to do something like "if prj_pointid[currentrow] = prj_pointid[i + 1]
than read fund_name for the row [i+1] and concat the name to
fund_name[currentrow].
Hope this makes sense.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:260760
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
