I have done something similar for a search by creating an additional search table, running my 3 queries and populating my new table with the results. In my case I have a job that indexes the search and populates the table.
>From memory the search table is literally a field with text in it collated from whatever was in the other tables I wanted to search, plus title and url fields for the search results page. I did a %like% search on the text field in my new table, and outputted the heading and URL into the search results. This is cumbersome but it works. I am interested to see what anyone else comes up with for this! I guess if you extended this into Verity you could possible also rate the search results? Mark > Anyone know of any easy way to query 3 different tables, but > outputting the results of a search as one single record set ? > I have tried unions, running 3 seperate select statements > inside the one <cfquery>, the tables are quite different in > structure so the union doesnt want to play.. There is no > relational aspects between the tables so a join wont work either. > > Is there a way to run 3 seperate queries and then combine the > results into a single collection for output? I want to do the > next/previous across the search results page also hence the > complexity.. > > Any ideas or thoughts appreciated.. > > Jason --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
