I don't believe that will get him what he wants. He has query #1 which will get the total records for a query. Query #2 just returns 50 records of the total.
So when you display results you see. Total: Records 4530 Displaying Records: 101-150. Instead of one query returning all 4530 records just to display 50 he is just bringing back what he needs. -----Original Message----- From: Deanna Schneider [mailto:[EMAIL PROTECTED] Sent: Thursday, February 02, 2006 1:43 PM To: CF-Talk Subject: Re: SQL Encapsulation? I'd go the cfc route, where I would instantiate a single CFC that would run your base query with all your where and from clauses. Then, I'd have multiple functions that would do query of query against that base query. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:231173 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