coldfusion - Odd placement of event in schedule -


i have page shows schedule of events on period of time. leigh on site, able working way wanted, except 1 small issue. 1 of events placed @ bottom of 1 of lists sorted datetime column "eventtime". i'm baffled.

here's code:

   <cfquery datasource="fairscheduledb" name="getfairevents">     select  fd.fairdaydate, fd.daycolor, fd.description, ev.eventname, ev.eventday, t.eventtype, ev.eventtime        fairdays fd           left outer join events ev on ev.eventday = fd.fairdaydate           left outer join eventtypes t on t.eventtype = ev.eventtype     order fd.fairdaydate, t.id, ev.eventtime    </cfquery>  <cfoutput query="getfairevents" group="eventday">     <div class="schedulebox">         <!--- display event dates --->         <div class="schedulehead" style="clear: both; color: ###daycolor#;">#dateformat(fairdaydate,"dddd, mmmm dd")#</div>         <div class="schedulesubhead" style="clear: both; color: ##ffffff; background: ###daycolor#;">#description#</div>         <!--- event types current date --->         <cfoutput group="eventtype">             <div class="scheduleitemtitle" style="clear: both; width: 700px; color: ###daycolor#;">#eventtype#</div>             <!--- individual events --->             <cfoutput>                 <div class="scheduleitem" style="float: left; width: 75px; text-align: right;"><strong>#lcase(timeformat(eventtime,"h:mmtt"))#</strong></div>                 <div class="scheduleitem" style="float: left; width: 550px;"> #eventname#</div><br/>             </cfoutput>         </cfoutput>     </div> </cfoutput> 

you're grouping output on eventday , eventtype. need add 2 columns order by, otherwise can unpredictably-ordered results.

order fd.fairdaydate, t.id, ev.eventday, ev.eventtime, ev.eventtype 

Comments

Popular posts from this blog

php - regexp cyrillic filename not matches -

c# - OpenXML hanging while writing elements -

sql - Select Query has unexpected multiple records (MS Access) -