Tricky one? MSSQL 'image' data into CDO.Message attachment

[codestorm]

How to do it?
I can add attachments to CDO.Message objects easily enough using Attachments.Add &quot;<path and filename>&quot;, but how to read some binary data (e.g. an image or PDF stored in a database) into a CDO.Message attachment? codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>

 

[NickBulka]

You'll need to first get the file out of the database and write it to the disk. There are two methods in ADO to do this: GetChunk and the Stream Object. Using the stream object is, IMO, the best approach.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q258038

nick bulka

 

[codestorm]

hmm, I'll take a look at it, although I was sure there'd be a way without having to resort to and intermediate step of writing it to HDD codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>