ok i have thr code below but nothing displays against the
times ie
the page displys fine but no records get attached to the time
slots
<cfquery name="GetClients"
datasource="#application.ds#">
SELECT PlayerFirstName, PlayerSurname, DiaryWith, DiaryTime
AS StartTime,
DATE_ADD('DiaryTime',INTERVAL Duration MINUTE) AS EndTime
FROM Diary_Table C
INNER JOIN SMS_Players_Table f ON C.DiaryPlayerID =
f.PlayerID
WHERE C.DiaryDate = <cfqueryparam
value="#session.SHORTDATE#" cfsqltype="CF_SQL_TIMESTAMP">
</cfquery>
<cfset steptime = getevents.starttime>
<cfloop condition="DateCompare(StepTime,
getevents.EndTime) LT 1">
<cfquery name="GetAppointment" dbtype="query">
SELECT PlayerFirstName, PlayerSurname, DiaryWith
FROM GetClients
WHERE StartTime <= <cfqueryparam value="#steptime#"
cfsqltype="CF_SQL_TIMESTAMP">
AND EndTime >= <cfqueryparam value="#steptime#"
cfsqltype="CF_SQL_TIMESTAMP">
</cfquery>
<cfoutput>
<tr bordercolor="##000066">
<td bgcolor="##CCCCCC"
class="StandBlack">#TimeFormat(StepTime, "hh:mm")#</td>
<td bgcolor="##CCCCCC"
class="StandBlack">#GetAppointment.PlayerFirstName#
#GetAppointment.PlayerSurname#</td>
<td bgcolor="##CCCCCC"
class="StandBlack">#GetAppointment.DiaryWith#</td>
<td bgcolor="##CCCCCC"><div
align="center"><cfif GetClients.PlayerSurname is not ''>
<a href="SMS_Recipients.cfm"
onclick="newWin(this.href,350,250,'no','yes'); return
false;"><img src="images/dtick.gif" width="15" height="17"
border="0"></a>
</cfif></div></td>
<td bgcolor="##CCCCCC"><div align="center">
<cfif GetClients.PlayerSurname is not ''>
<a href="SMS_Schedule_Delete.cfm"><img
src="images/dx.gif" width="15" height="17" border="0"></a>
</cfif></div></td>
</tr>
</cfoutput>
<cfset StepTime = dateadd("n", getevents.Increment,
StepTime)>
</cfloop>