>> There's nothing wrong with what you're doing. It's just that >> each of these collections contain WILDLY different data that >> will determine which page the results are displayed on. I was >> following Dave Watts' Solution, but the Union of Queries seems >> like the best one so far, and it's working perfectly. See, each >> collection is a Collection on a Query, and I'm assigning "Key, >> Title, Body, Custom1, Custom2" wildly different values. I'm >> assigning custom2 a value when the index is created to flag >> which table it's coming from, then I'm using the key value, >> the title, and the custom2 to pass combined results to a >> "redirect" page which will perform additional queries (if >> necessary, some may be able to simply be passed on with the >> information they contain, others may have to have additional >> queries run to get additional information that's required to >> display that particular information). >> >> I was just planning on putting it in a switch statement that >> will do the appropriate redirecting to the appropriate display >> page. >> >> See, I'm hip to what you're saying, and I *hope* I'm not making >> it more complicated than it needs to be, but I'm indexing about >> ten collections that will all contain wildly different information >> contained in tables that will need to almost all be displayed >> differently, but need to be searched from a single, common >> interface. > >I might be missing something, but I'm not sure how unioning the two queries >is going to help you when you get to displaying the records, since you'll >still need some sort of differentiating factor at that point. > >Dave Watts, CTO, Fig Leaf Software >http://www.figleaf.com/ >voice: (202) 797-5496 >fax: (202) 797-5444
Perhaps the two separate member queries of the UNION could select a custom column that shows which type each record is: SELECT a, b, c, 'foo' AS recordtype FROM something UNION SELECT d, e, f, 'bar' AS recordtype FROM somethingElse Will this do the trick? Mike Mertsock Alfred University Web Team ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com
