Not sure if I've read your question right, but heres a tip:
The group attribute can often be used to avoid the need for arrays.
Try this:
<cfset myquery = querynew("")>
<cfset queryaddrow(myquery,5)>
<cfset queryaddcolumn(myquery,"PRJ_PointID",listtoarray("87,88,88,88,89"))>
<cfset
queryaddcolumn(myquery,"PRJ_MainID",listtoarray("197,198,198,198,199"))>
<cfset queryaddcolumn(myquery,"Fund_Name",listtoarray("B2B,B2b,Bond
2004,B2B,CDBG"))>
<cfdump var="#myquery#">
<cfoutput query="myquery" group="PRJ_MainID">
#PRJ_PointID#,
#PRJ_MainID#,
<cfoutput>
,#fund_name#
</cfoutput>
<br>
</cfoutput>
The output is not exactly the same as your desired output, but Im hoping
thats because of a typo on your part!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:260867
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
