Skip to main content
Participant
September 30, 2008
Question

Saving email Orders to database

  • September 30, 2008
  • 1 reply
  • 233 views
I am trying to figure out how to save a complicated email to a database. It is actually an invoice. This has session variables and pulled database variables in the email. Basically, in theory I can go in and do a

<cfset emailBody="<table> <tr> <td>" & #coldfusionVariable# &" </td></tr></table>">

But this is very simplistic demo - My invoice is very complicated. What I am hoping is there is a way to dump the email body into a database and then bring it back later by just dumping it into html.

I have had several cusotomers complain about not getting emails ( orders ) for one reason or another. I process them now by saving each order and order details and session variables, but it gets really complicated when I try to do any updating. I don't undertand that if you can change out the <cfmail> tags and input <cfoutput> tags and see your email - why can't you dump that html to a database?

There's gotta be a way.
This topic has been closed for replies.

1 reply

BKBK
Community Expert
Community Expert
September 30, 2008
What's your Coldfusion version? Database server? Could you show a realistic example of the kind of email you wish to dump?