Query output to multiple columns (list?)
I have a query that extracts data about companies, people and offices. After I display the company info, I want to display the people/office data in 2 columns, with a list of people on the left and offices on the right. There is no correlation between the 2 columns, i.e. I will have a list of all of the company's people on the left, and all of the company's offices on the right.
I can do this with cfoutput into a table with 2 TD areas, and this works fine for a company with 1 employee and 1 office, a matching number of employees and offices, and 1 of either with multiples of the other. If I do this output with non-matching multiples of both, I end up with wierd looking lists with data that does not show up side by side.
I was told that the best way for me to do this is with Lists, but I cannot seem to find any clear instructions, or good examples, on how to do this.
Anyone?
