Ooooh... Must be a way to do it with a group by statement on the cfoutput...
Otherwise I'm going to be no help at all... sorry. Mark On Fri, 14 Jan 2005 08:20:26 +0800, Peter Galipo <[EMAIL PROTECTED]> wrote: > the query would be output like so (just like an access crosstab query): > > blue green red > shirt 1 6 2 1 > shirt 2 1 0 0 > > 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. > > Thanks, > > Pete > -- E: [EMAIL PROTECTED] W: www.compoundtheory.com ICQ: 3094740 --- 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/
