Chaitra Kear wrote:As you said, I don't think I need FreeMarker at all, because my email isn't going to be complicated
Then why did you feel you needed JSP? I assumed it was because you needed templating for the email body.
However MySQL by itself cannot send the email I believe.There were suggestions on the net to make the trigger run an external script(written in PHP ) which does this
If this is a cron job, why not just do it from the shell? If you don't need templating, you could likely just use the mail shell command. (Or is this running on Windows? I assume not.)
And there's this JavaMail API
That's what you would use if you were to do this from
Java.