I have a query that selects all performers in the current
week. There are many rooms that a performer can be scheduled in and
sometimes there is no performer scheduled in a particular room or
at a particular time.
The query looks like this:
<cfquery datasource="#application.ds#" name="qrySchedule"
maxrows="1">
select *
from SHOW_SCHEDULE
WHERE calend >= #createodbcdate(now())#
order by calend asc
</cfquery>
The table row has about 20 fields ie; room1earlyperformer1,
room1lateperformer1, room1earlyperformer2, room1lateperformer2,
room2earlyperformer1, room2lateperformer1, room2earlyperformer2,
room2lateperformer2 ...etc.
I would like to be able to display this query output in a 2
column table while not leaving any table cells blank if there is no
performer scheduled in a particular room at a particluar time.
Can someone please help with a code example? Thank
you!