Good morning/afternoon/evening all,
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:
<p class="bold">
<cfoutput>#getSchoolBusRoutesRet.School_Name#</cfoutput>
</P>
<P>
<cfoutput query="getSchoolBusRoutesRet" group="Route_Name">
<cfif getModifiedBusSchedulesRet.RecordCount GT 0>
<table align="center" cellpadding="2"
cellspacing="2" border="0" width="80%">
<tr>
<th colspan="4">
#School_Name#
#Route_Name# (Modified)
</th>
</tr>
<cfoutput>
<tr class="contacts_cell">
<td width="52%">
#StreetName#
</td>
<td width="4%">
(#Side#)
</td>
<td width="22%">
#Pick_Up#
</td>
<td width="22%">
#Drop_Off#
</td>
</tr>
</cfoutput>
</table>
<cfelse>
<table align="center" cellpadding="2"
cellspacing="2" border="0" width="80%">
<tr>
<th colspan="4">
#School_Name#
#Route_Name#
</th>
</tr>
<cfoutput>
<tr class="contacts_cell">
<td width="52%">
#StreetName#
</td>
<td width="4%">
(#Side#)
</td>
<td width="22%">
#Pick_Up#
</td>
<td width="22%">
#Drop_Off#
</td>
</tr>
</cfoutput>
</table>
</cfif>
</cfoutput>
</P>
Any help would be appreciated.
Thanks,
Bruce
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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:295037
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
