>
> <cfloop from="1" to="#rows#" index="i">
> <tr height="15%">
> <cfloop from="1" to="7" index="j">
> <td align="left" valign="top">
> <cfif #page[j][i]# is -1>
>
> <cfelse>
>
> <!-- Outputting the DAY number-->
> <h2><cfoutput>#page[j][i]#</cfoutput> </h2>
>
> <span class="bodyCopy">
>
> <cfquery name="getByDay" datasource="#request.DSN#">
> SELECT
> DOC_FIRST_NAME,
> DOC_LAST_NAME,
> START_MONTH,
> START_DAY,
> START_HOUR,
> START_AMPM,
> END_DAY,
> END_MONTH,
> END_HOUR,
> END_AMPM
> FROM
> DOCTORS, DIVISIONS, ONCALL_SHIFTS
> WHERE
> ONCALL_SHIFTS.DIVISION_ID = <cfqueryparam
> cfsqltype="cf_sql_integer" value="9">
> AND
> DIVISIONS.DIVISIONID = ONCALL_SHIFTS.DIVISION_ID
> AND
> ONCALL_SHIFTS.DOCTOR_ID = DOCTORS.Doc_ID
> AND
> <cfqueryparam cfsqltype="cf_sql_integer" value="#page[j][i]#
> ">BETWEEN START_DAY AND END_DAY
> AND
> <cfqueryparam cfsqltype="cf_sql_integer" value="#URL.M#">
> BETWEEN START_MONTH AND END_MONTH
>
> </cfquery>
<!-- Outputting the doctor who is scheduled for this particular day-->
<cfoutput query="getByDay"><strong>#Doc_Last_name#</strong>
<!-- If there is an start time other than the default 8AM-->
<cfif getByDay.START_HOUR NEQ 8 AND getByDay.Start_Day IS page[j][i]>
<br><em>ON: #getByDay.START_HOUR##getByDay.START_AMPM#</em>
</cfif>
<!-- If there is an end time other than the default 8AM-->
<cfif getByDay.END_HOUR NEQ 8 getByDay.End_Day IS page[j][i]>
<br><em>OFF:#getByDay.END_HOUR##getByDay.END_AMPM#</em>
</cfif>
<br>
</cfoutput>
</span>
</cfif>
</td>
</cfloop>
</tr>
</cfloop>
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
