I'm trying to send email using the stored procedure called sp_send_cdosysmail through a coldfusion page. The stored procedure can be found here http://support.microsoft.com/default.aspx?scid=kb;en-us;312839&sd=tech
under the section "Create a Stored Procedure to Send CDOSYS Mail". I'm passing in the required variables From, To, Subject, and Body. If I run the query thorugh query analyzer the mail gets sent. If I call the stored procedure through the webpage it is not sent. Here's my code for calling the procedure. The stored procedure is in the Master database.
type="in" value="firstname.lastname@example.org" dbvarname="@To">
type="in" value="email@example.com" dbvarname="@From">
type="in" value="Order Confirmation" dbvarname="@Subject">
har" type="in" value="This is the body of the email" dbvarname="@Body">
When I call the procedure from the website I don't get an error message. I've used an output variable to make sure the values where being passed in and the result were the values that were passed in.
Can anyone shed some light on this situation?