I'll do that tomorrow when I get to work. Cannot access the SQL Server from home. Oh, and it is good to see you back Issac.
-----Original Message----- From: s. isaac dealey [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 18, 2007 6:21 PM To: CF-Talk Subject: Re: data not outputting correctly Hey Bruce, not sure if you've had any responses on this... The code you posted looks fine, but it doesn't look like the place where your problem is going to be located. By the time you get to the <cfoutput> tag, the sorting's pretty well done with (and your grouping looks fine, although I usually group on the primary key column -- I'm not sure if route_name is your primary key). Could you post the TSQL for your stored procedure and/or the cfstoredproc tags your using to fetch that query? ike -- s. isaac dealey ^ new epoch isn't it time for a change? ph: 503.236.3691 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:295079 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
