Ben Nadel posted a couple good way to do this. (His site is awesome) First, and the fastest method a method using Structures as key lookups. http://www.bennadel.com/blog/268-Structs-As-Query-Indexes-Speed-And-Rick-Osborne.htm
Second, using the query objects indexOf() method. http://www.bennadel.com/blog/267-Ask-Ben-ColdFusion-Optimization-A-Case-Study.htm Hope that helps. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:325189 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
