> Unfortunately there is no crosstab query in SQL Server, so what I've > been doing > is taking the query and doing a fair bit of code to get the query into > the format > shown above. I'm wondering if there is an easier way to do it.
Look at the grouping attribute on the cfoutput tag. Order your db query correctly then group on each element needed. ie shirt, color, etc. hth Rod --- You are currently subscribed to cfaussie as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
