Don't know if your doing any grouping in the query, but you are in the output. Is it possible that this grouping is somehow reordering the query? I would look at the query again only because I am seeing data duplication on route 11 and time values out of order on several routes (i.e. 8, 18 and 13).
> -----Original Message----- > From: Bruce Sorge [mailto:[EMAIL PROTECTED] > Sent: Tuesday, December 18, 2007 1:27 PM > To: CF-Talk > Subject: data not outputting correctly > > 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:295074 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
