Hello All, I hope i'm providing enough info for this question.
I have a query that retrieves from several different tables. Because the result list can run into the hundreds, I use <cfloop query="qGetTitleList" startrow="#URL.startRow#" endrow="#endRow#" > to group the output by tens. I recently added a left join to the query that could include multiple rows from another table. When I run the query, a record from the first query repeats itself as many times as a matching record occurs in the second table. If I strip out the cfloop tag and use only <cfoutput query="qGetTitleLIst" group="reviewpk"> The output runs as I expect it to. This of course does not allow for grouping by 10. Any suggestions? Thanks in advance, jahlen ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:4233 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
