Larry,
Not sure exactly what you're going for. But rather than go into array usage
(and looping a collection), which you can probably learn better elsewhere,
maybe there's a simpler way to attack the problem.
In the end, you seem to simply want to go over a query result:
<cfquery name="GetLats" datasource="#SESSION.ds#">
SELECT tblLaterals.latID,
tblLaterals.lateralID,
tblLaterals.Why,
[FirstName] & Chr(32) & [LastName] AS Who,
tblPlayers.Title,
tblPlayers.TX,
tblPlayers.FAX,
tblPlayers.Email,
tblLaterals.DateSent
FROM tblLaterals LEFT JOIN tblPlayers ON
tblLaterals.lateralID = tblPlayers.playerID
WHERE tblLaterals.MasterID=#SESSION.
Report.MasterID#
ORDER BY [FirstName] & Chr(32) & [LastName];
</cfquery>
... and output it onto the page. Now, I'm assuming that you're stuffing the
results into the session scope because you need to use it more than one
place. But I can't see why you need to create the array or do all that
looping.
Can't you simply place the query result into the session scope:
<cfset session.Report.Lats = getLats />
... then output it on the page:
<cfif session.Report.Lats.recordCount GT 0>
<cfoutput query="session.Report.Lats">
... and built your list item here.
</cfoutput>
</cfif>
Or have I missed what you're going for?
--
Thanks,
Tom
Tom McNeer
MediumCool
http://www.mediumcool.com
1735 Johnson Road NE
Atlanta, GA 30306
404.589.0560
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:330421
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
