Hi,
I'm trying to group timezone information into a table. The problem I am
having is the looping through the values of same time zone(ET), same
day(Monday), sorting(start with 12:00AM for AM, and start for 12:00PM
for PM column) and filling them into two columns one of which AM values
only, and second PM values only.
Is it possible to write a grouping function for this request? If yes any
help is appreciated.
Thanks,
Cihan
Output sample:
------------------------------------------------------------------------
---------------------------------
Monday
<table width="542" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="55" align="right"> AM VALUES</td>
<td width="55" align="right"> PM VAULES</td>
</tr>
<tr>
<td width="55" align="right"> AM VALUES</td>
<td width="55" align="right"> PM VAULES</td>
</tr>\
and so on....
</table>
Tuesday
<table width="542" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="55" align="right"> AM VALUES</td>
<td width="55" align="right"> PM VAULES</td>
</tr>
<tr>
<td width="55" align="right"> AM VALUES</td>
<td width="55" align="right"> PM VAULES</td>
</tr>\
and so on....
</table>
------------------------------------------------------------------------
---------------------------------
---------------XML file-------
<main_schedule>
<schedule>
<prog ID="1" title="Asthma">
<timezone value="ET">
<airing day="Monday">
<time value="1:00am"/>
<time value="9:00am"/>
<time value="5:00pm"/>
</airing>
<airing day="Tuesday"/>
<airing day="Wednesday"/>
</timezone>
<timezone value="CT">
<airing day="Monday">
<time value="12:00am"/>
<time value="8:00am"/>
<time value="4:00pm"/>
</airing>
<airing day="Tuesday"/>
<airing day="Wednesday"/>
</timezone>
<timezone value="MT">
<airing day="Monday">
<time value="7:00am"/>
<time value="3:00pm"/>
</airing>
</timezone>
</prog>
<prog ID="2" title="Cancer">
<description><![CDATA[Cancer is...]]></description>
<timezone value="ET">
<airing day="Monday">
<time value="6:30am"/>
<time value="2:30pm"/>
<time value="10:30pm"/>
</airing>
<airing day="Tuesday">
<time value="6:30am"/>
<time value="2:30pm"/>
<time value="10:30pm"/>
</airing>
<airing day="Wednesday">
<time value="6:30am"/>
<time value="2:30pm"/>
<time value="10:30pm"/>
</airing>
</timezone>
<timezone value="CT">
<airing day="Monday">
<time value="5:30am"/>
<time value="1:30pm"/>
<time value="9:30pm"/>
</airing>
<airing day="Tuesday">
<time value="5:30am"/>
<time value="1:30pm"/>
<time value="9:30pm"/>
</airing>
<airing day="Wedensday">
<time value="5:30am"/>
<time value="1:30pm"/>
<time value="9:30pm"/>
</airing>
</timezone>
</prog>
</schedule>
</main_schedule>