September 11, 2008 at 3:35 am
Hi Guys.
I have been trying to figure this one our for a while and i am not sure that its even possible.
I am building an HTML email in a stored proc that will be sent out using Database mail.
At the moment i am setting a variable that will be the body of the email to a HTML template. I am then replacing various markers with data items pulled from the database. This is all working fine.
For the final part of the email i need to embed an image that is stored in the database under the data type Image.
Since image is a binary data type and HTML is not a proper programming language there is no way that i can see to embed this image within the stored proc.
Anyone have any ideas?
Thanks alot
September 11, 2008 at 8:22 am
I think the usual way to do that is to attach the image as a file to the e-mail and then include an HTML reference to the attachment. I haven't done this, but I think that's what I've seen. (I am not an HTML expert by any means, so I could be dead wrong.)
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
September 11, 2008 at 8:25 am
Your Dead on the money there. Thats what i am working on now. Will post in a bit with how its done.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply