For further manipulation, it's also sometimes handy to remember that a query object is essentially a struct of arrays, with the selected columns at struct keys.
So you can also do things like: <cfif Session.Report.lats.recordCount GT 0> <cfloop from="1" to "#Session.Report.lats.recordCount#" index="i"> .... do something with Session.Report.lats.Why[i] </cfloop> </cfif> Of course, you can always just <cfloop query="Session.Report.lats"> and avoid the use of the index. Just thought I'd point out that you can access individual records in the array for each column with array notation. -- 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:330445 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
