That might be a good idea. Could you create a query just of UUIDs and store that in the Application? Then Join to it via the QoQ?
I don't often perform joins in QoQ as I don't like the syntax, but it's a sound idea. Is the UUID list constant? Or is that changing from page to page as well? ....................... Ben Nadel www.bennadel.com -----Original Message----- From: Aaron Rouse [mailto:[EMAIL PROTECTED] Sent: Tuesday, April 25, 2006 11:39 AM To: CF-Talk Subject: Re: replacement for QoQ Or make a query of the UUIDs and then do a join onto that within the QoQ. I do not use QoQ's much at all and threads like this make me fearful of those times I did use it. On 4/25/06, Hugo Ahlenius <[EMAIL PROTECTED]> wrote: > > Or how > about replacing the in statement with repeated UUID = "X" OR statements. > > /H. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:238615 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54

