on 8/22/03 11:38 AM, Ben Doom at [EMAIL PROTECTED] wrote: > Maybe I'm missing something. I currently have code up in CF 5 as such: > > <CFSEARCH name="results" collection="#request.collections#" > criteria="#request.searchstring#"> > > where request.collections can contain more than one collection, and it > searches all of them. I just tested this and it works fine. > > Has something changed in MX or RedSky? Or is this just a problem of habit > making people look for complicated solutions?
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. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
