> But as I said you can use most array functions on query > columns (generally > those that don't affect the order or the number of items > in the array). > Want a total of a column of numbers? Don't loop! Use > ArraySum(queryname.columname).
> It's pretty powerful stuff when you know the limitations. I've found these to be "syntactically flaky" between cf5 and cfmx -- that is -- syntax which allows you to use a query column with an array function with CF5 won't work on MX or vice versa. On a given version, there are consistent behaviors and I ended up creating a QueryColumnToArray() function to control the syntax for this purpose. s. isaac dealey 954.522.6080 new epoch : isn't it time for a change? add features without fixtures with the onTap open source framework http://www.fusiontap.com http://coldfusion.sys-con.com/author/4806Dealey.htm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207619 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
