Sorry, that was a typo..I was copying and pasting the columns into the group by rollup.
Cheers, Teddy On 1/26/07, Paul Hastings <[EMAIL PROTECTED]> wrote: > > Teddy Payne wrote: > > SELECT <cfswitch expression="#Sort#"> > > <cfcase value="State">State</cfcase> > > <cfcase value="County">County</cfcase> > > <cfcase > > value="CTV_County">CTV_County</cfcase> > > </cfswitch>, > > > is the cfswitch even necessary, can you just use #sort# instead? > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:267723 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
