Hi all,
I've an issue with the output of a query. I want to create an output that spans
timeslots. I think I might have to do a series of nested loops and queries or
some self joins but I can't get my head round it. Within my sample data any
number of groups (which relates to columns) can be created. Start & end times
(which relates to rows) can be set to anything.
Here's the sample data
| sTime | eTime | groupkey | groupTitle | talkTitle |
------------------------------------------------------
| 09:30 | 10:15 | xyz | Stream A | Hi1 |
| 10:15 | 11:00 | xyz | Stream A | Hi2 |
| 11:00 | 11:45 | xyz | Stream A | Hi3 |
| 09:15 | 10:00 | abc | Stream b | bye1 |
| 10:00 | 10:30 | abc | Stream b | bye2 |
Example output:
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>Time</td>
<td>Stream A</td>
<td>Stream B</td>
</tr>
<tr>
<td>09:15</td>
<td> </td>
<td rowspan="3">bye1</td>
</tr>
<tr>
<td>09:30</td>
<td rowspan="2">Hi1</td>
</tr>
<tr>
<td>10:00</td>
</tr>
<tr>
<td>10:15</td>
<td rowspan="3">Hi2</td>
<td rowspan="2">Bye2</td>
</tr>
<tr>
<td>10:30</td>
</tr>
<tr>
<td>11:00</td>
<td> </td>
</tr>
<tr>
<td>11:45</td>
<td>Hi3</td>
<td> </td>
</tr>
</table>
Any ideas how to go about doing this?
Thanks,
Richard
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:276608
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
