> 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com
