> I am outputting some data for our bus schedules and I am having a
> problem getting it to display in the right order. When I run my stored
> procedure in SQL Server Management Studio the information outputs
> correctly (the order by clause is working). When I display it in my CF
> code or dump the query, it displays in what appears to be random order.
> You can see what I am talking about at http://www.snowline.k12.
> ca.us/busschedule.cfm?School_ID=10. It should be listing by route name
> starting with route 6 and working it's way up to 27. Here is the code
> below:
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:295077
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
