Randall; In the code you posted, you have a query called "qGetNotification" and a variable in your email called "qGetNotifications.recordcount". If you look carefully, you will see the two are not the same.
I don't know, maybe agreement between the variable names will solve the problem. Let me know if this solves it. M -----Original Message----- From: Randell B Adkins [mailto:[EMAIL PROTECTED] Sent: Monday, June 02, 2003 11:19 AM To: CF-Talk Subject: 500 Internal Service Error WAS ( Signal 11 & CF Services ) Well not atleast I am not getting th esignal 11 this time. Now the error is: 500 Internal Server Error This time the ONLY thing I did was add in the CFMAIL tag. So when these are ran together I get the 500 error now. /Still Searching -------------- Any suggestions ? Application.cfm: <CFAPPLICATION NAME="webTASchedules" CLIENTMANAGEMENT="No" SESSIONMANAGEMENT="No"> test_one.cfm <CFSET thisDate = #DateFormat(Now(), "MM/DD/YYYY")#> <CFSET VARIABLES.DSN = "webTAdev"> <!--- Get Notification Information ---> <CFQUERY NAME="qGetNotification" DATASOURCE="#VARIABLES.DSN#"> SELECT SUBJECT FROM NOTIFICATION_TYPE </CFQUERY> <CFMAIL TO="[EMAIL PROTECTED]" FROM="[EMAIL PROTECTED]" SUBJECT="Another Test" SERVER="mailserver.gao.gov"> There are #qGetNotifications.recordcount# subjects within the Notification Type Table.</CFMAIL> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
