The columns that go into the group by must be the original name of the column and not the aliases.
Cheers, Teddy On 1/26/07, Michele Michele <[EMAIL PROTECTED]> wrote: > > >Sorry, that was a typo..I was copying and pasting the columns into the > group > >by rollup. > > > >Cheers, > >Teddy > > > Hi Teddy- > Unfortunately, there were many more cartoon characters there, the rollup > balked. I took that switch in the select out, and I am wondering if I can > give those three columns an alias, and then refer to the alias when rolling > up. I am far from an expert here, just stumbling along! > > Thanks for your help! > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 Experience Flex 2 & MX7 integration & create powerful cross-platform RIAs http:http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:267733 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
