ChiefJoseph
Programmer
I need to call apon the power of the cold fusion gods
Heres what i got,
<CFQUERY NAME="DateFindQuery" DATASOURCE="Callender" DBTYPE="ODBC">
SELECT MessageDay
FROM UserMessage
WHERE ((MessageMonth='#mo#' AND MessageDay='#count#' AND MessageYear='#year#'))
</CFQUERY>
<CFIF DateFindQuery.RecordCount greater than 0>
<td width='14%' height='70' bgcolor='#EEEEEE' align='right' valign='top'><font face='verdana,arial,helvetica' size=1><b>
<CFOUTPUT><a href=main.cfm?Year=#year#&Month=#mo#&Day=#count#></CFOUTPUT><font color=#FF0000>
**Here is the problem**
<CFOUTPUT QUERY="DateFindQuery">#count#
<CFIF #MessageDay# EQ #count#> <p><div align='center'><img src='reminder.gif' width='10' height='10'></div> </CFIF></CFOUTPUT>
</CFIF>
The goal of this is to check the database if there is a message for that day and display a warning. The problem is if there is more than one message for that day it shows my output that many times.
I've tried alot of things but nothing works.
Any Ideas?
Heres what i got,
<CFQUERY NAME="DateFindQuery" DATASOURCE="Callender" DBTYPE="ODBC">
SELECT MessageDay
FROM UserMessage
WHERE ((MessageMonth='#mo#' AND MessageDay='#count#' AND MessageYear='#year#'))
</CFQUERY>
<CFIF DateFindQuery.RecordCount greater than 0>
<td width='14%' height='70' bgcolor='#EEEEEE' align='right' valign='top'><font face='verdana,arial,helvetica' size=1><b>
<CFOUTPUT><a href=main.cfm?Year=#year#&Month=#mo#&Day=#count#></CFOUTPUT><font color=#FF0000>
**Here is the problem**
<CFOUTPUT QUERY="DateFindQuery">#count#
<CFIF #MessageDay# EQ #count#> <p><div align='center'><img src='reminder.gif' width='10' height='10'></div> </CFIF></CFOUTPUT>
</CFIF>
The goal of this is to check the database if there is a message for that day and display a warning. The problem is if there is more than one message for that day it shows my output that many times.
I've tried alot of things but nothing works.
Any Ideas?