Thanks guys. But I think we are slightly deviating from my original intent :-)
I need some functionality as it happens in hibernate. You do a query in hibernate, it will fetch 100 records. Now when you again do query (which should now return 150 records), hibernate will fetch just remaining 50 records from DB and rest from some sort of cache it maintains. Thus it gives performance boost. We can use Transfer ORM in CF for same kind of functionality but as soon as we write TQLs, it no more behaves like hibernate and will fetch 150 records(instead of 50) from the DB for this second query. So I need some way to achieve the hibernate sort of functionality. I think I did not confuse you a lot. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:332254 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
