Thanks for everybody's input. I ended up with a cfc with three methods. 1-getQuery1 2-getQuery2 3-getBothQueries
This way I have access to either query one, OR query two, or both combined. I guess I can't see a better way to do it. On Thu, 21 Oct 2004 13:03:04 -0600, Scott Brady <[EMAIL PROTECTED]> wrote: > On Thu, 21 Oct 2004 10:06:05 +0800, James Holmes wrote: > > Do a UNION in the QoQ instead of a join. > > I thought the point was that he wanted not to do a UNION in SQL (still > not clear on why). I can't imagine doing a UNION in a QoQ would serve > a purpose better than just doing a UNION to begin with. > > Scott > > -- > ----------------------------------------- > Scott Brady > http://www.scottbrady.net/ > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Purchase from House of Fusion, a Macromedia Authorized Affiliate and support the CF community. http://www.houseoffusion.com/banners/view.cfm?bannerid=36 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:182279 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