I just can a query with the WHERE, AND and I get data return.
I also modified the code by taking the cfoutput statement out. I
still get no mail. I also check in CF admin and the mail server is
running. Any other sugguestions please.
<cfparam name="notifyDate" default="#DateFormat(Now(),
"short")#">
<CFQUERY name="getNotifications" datasource="AEDWEB">
SELECT u.strEmail,
u.strFirstName,
u.strLastName,
cc.strCCNoteEmailBody
FROM umsUsers u,
ctsConferenceCalls cc
WHERE cc.dtsCCNotificationDate = '#notifyDate#'
AND u.intCCNotify = 1
AND u.intMemberstatus = 1
</CFQUERY>
<CFMAIL TO="#strEmail#" FROM="notification@ccicom.com"
SUBJECT="Conference Call Reminder" SERVER="mail.ccicom.com"
port="25">
#strCCNoteEmailBody#
</CFMAIL>