Hi there, How are you doing this iterator exactly? I have just made and been using my own dao iterator base component and it has so far been really fast and easy to use (and dang handy, definately a good idea). I would loop like so:
<cfloop condition="myIteratorObj.Next()"> #myIteratorObj.GetTitle()# </cfloop> Under the hood, the object contains the query and maintains a pointer to the current row - any time you use any of the object's methods, the method uses the data from the current row of the query. This way, there are no conversions happening and so performance is not an issue. I can send you the classes (dao and daoIterator) and an example object that extends them if you like? I think they are easy to read so you should be able to take from them what you will (and ditch what you won't). Dominic -- Blog it up: http://fusion.dominicwatson.co.uk ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298369 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
