SQL Server Requires Chilkat v11.0.0+

Save a MIME Body to a File

See more MIME Examples

Demonstrates how to save a MIME body to a file. The MIME data file used in this example is available at MIME Sample File. SQL Server

--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  This example requires the Chilkat API to have been previously unlocked.
    --  See Global Unlock Sample for sample code.

    DECLARE @mime int
    EXEC @hr = sp_OACreate 'Chilkat.Mime', @mime OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    --  The contents of this MIME file are shown below, 
    --  and is also available at https://www.chilkatsoft.com/sampleMime.txt
    EXEC sp_OAMethod @mime, 'LoadMimeFile', @success OUT, 'qa_data/mime/sampleMime.txt'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mime, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mime
        RETURN
      END

    --  The MIME used in this example has the following nested structure
    --  
    --  multipart/alternative
    --      text/plain
    --      multipart/related
    --          text/html
    --          image/jpeg
    --  

    --  This example will save each of the non-multipart parts.
    --  It will create three files -- a .txt, .html, and .jpg.

    --  Save the body of the text/plain part.

    DECLARE @pTxt int
    EXEC @hr = sp_OACreate 'Chilkat.Mime', @pTxt OUT

    EXEC sp_OAMethod @mime, 'PartAt', @success OUT, 0, @pTxt
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mime, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mime
        EXEC @hr = sp_OADestroy @pTxt
        RETURN
      END

    EXEC sp_OAMethod @pTxt, 'SaveBody', @success OUT, 'qa_output/textPart.txt'

    --  Save the HTML part.

    DECLARE @mpRelated int
    EXEC @hr = sp_OACreate 'Chilkat.Mime', @mpRelated OUT

    EXEC sp_OAMethod @mime, 'PartAt', @success OUT, 1, @mpRelated
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mime, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mime
        EXEC @hr = sp_OADestroy @pTxt
        EXEC @hr = sp_OADestroy @mpRelated
        RETURN
      END

    DECLARE @pHtml int
    EXEC @hr = sp_OACreate 'Chilkat.Mime', @pHtml OUT

    EXEC sp_OAMethod @mpRelated, 'PartAt', @success OUT, 0, @pHtml
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mpRelated, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mime
        EXEC @hr = sp_OADestroy @pTxt
        EXEC @hr = sp_OADestroy @mpRelated
        EXEC @hr = sp_OADestroy @pHtml
        RETURN
      END

    EXEC sp_OAMethod @pHtml, 'SaveBody', @success OUT, 'qa_output/htmlPart.html'

    --  Save the JPG binary data.  (The data is automatically base64 decoded prior to saving.)

    DECLARE @pJpg int
    EXEC @hr = sp_OACreate 'Chilkat.Mime', @pJpg OUT

    EXEC sp_OAMethod @mpRelated, 'PartAt', @success OUT, 1, @pJpg
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mpRelated, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mime
        EXEC @hr = sp_OADestroy @pTxt
        EXEC @hr = sp_OADestroy @mpRelated
        EXEC @hr = sp_OADestroy @pHtml
        EXEC @hr = sp_OADestroy @pJpg
        RETURN
      END

    EXEC sp_OAMethod @pJpg, 'SaveBody', @success OUT, 'qa_output/jpgPart.jpg'

    --  --------------------------------------------------------------
    --  --------------------------------------------------------------
    --  The MIME sample file loaded at the beginning of this example
    --  contains the following MIME:

    --  Subject: Test email.
    --  Content-Type: multipart/alternative;
    --  	boundary="------------DB171738719FB06D67DEBAA0"
    --  MIME-Version: 1.0
    --  
    --  --------------DB171738719FB06D67DEBAA0
    --  Content-Type: text/plain; charset="utf-8"; format=flowed
    --  Content-Transfer-Encoding: 7bit
    --  
    --  This is a test.
    --  
    --  --------------DB171738719FB06D67DEBAA0
    --  Content-Type: multipart/related;
    --  	boundary="------------A940F1230E6F0105F03DB2CB"
    --  
    --  --------------A940F1230E6F0105F03DB2CB
    --  Content-Type: text/html; charset="utf-8"
    --  Content-Transfer-Encoding: 8bit
    --  
    --  <html><head>
    --  <meta http-equiv="Content-Type" content="text/html; charset=utf-8">
    --    </head>
    --    <body bgcolor="#FFFFFF" text="#000000">
    --      <p>This is a test.&nbsp; <img src="cid:part1.E16AE3B4.1505C436@chilkatsoft.com" height="20" width="20"></p>
    --    </body>
    --  </html>
    --  
    --  --------------A940F1230E6F0105F03DB2CB
    --  Content-Type: image/jpeg; name="starfish20.jpg"
    --  Content-Transfer-Encoding: base64
    --  Content-ID: <part1.E16AE3B4.1505C436@chilkatsoft.com>
    --  Content-Disposition: inline; filename="starfish20.jpg"
    --  
    --  /9j/4AAQSkZJRgABAQEASABIAAD//gAmRmlsZSB3cml0dGVuIGJ5IEFkb2JlIFBob3Rvc2hvcD8g
    --  NC4w/9sAQwAQCwwODAoQDg0OEhEQExgoGhgWFhgxIyUdKDozPTw5Mzg3QEhcTkBEV0U3OFBtUVdf
    --  YmdoZz5NcXlwZHhcZWdj/9sAQwEREhIYFRgvGhovY0I4QmNjY2NjY2NjY2NjY2NjY2NjY2NjY2Nj
    --  Y2NjY2NjY2NjY2NjY2NjY2NjY2NjY2NjY2Nj/8IAEQgAFAAUAwERAAIRAQMRAf/EABcAAAMBAAAA
    --  AAAAAAAAAAAAAAIDBAX/xAAYAQADAQEAAAAAAAAAAAAAAAABAgMEAP/aAAwDAQACEAMQAAAB2kZY
    --  NNEijWKddfTmLgALWH//xAAbEAACAgMBAAAAAAAAAAAAAAABAgMRAAQSE//aAAgBAQABBQL0XqN+
    --  pM2aqJGMiqFFCyg7z//EABwRAAICAgMAAAAAAAAAAAAAAAERAAIQIQMSUf/aAAgBAwEBPwHqU5aq
    --  Axx+y1tMQl4elj//xAAcEQEAAQUBAQAAAAAAAAAAAAABEQACEBIhA1H/2gAIAQIBAT8B3Bhqy7Zc
    --  enyiwmGgDhiOzj//xAAdEAABAwUBAAAAAAAAAAAAAAABAAIREBIhIkFR/9oACAEBAAY/ArZyn+Cg
    --  xtxWuJaoCnqDuin/xAAcEAABBAMBAAAAAAAAAAAAAAABABEhYRAxQVH/2gAIAQEAAT8hkEwPUUR9
    --  DYfE4nxtRpIkBTsayuALIiuY/9oADAMBAAIAAwAAABDWPTsf/8QAGhEAAwADAQAAAAAAAAAAAAAA
    --  AAEREDFBIf/aAAgBAwEBPxC0DVPcWm+Ce4OesrkE6bjH/8QAGBEBAQEBAQAAAAAAAAAAAAAAAREA
    --  QRD/2gAIAQIBAT8QahMiOc8YgSrnTY3ELclHXn//xAAcEAEBAAIDAQEAAAAAAAAAAAABEQAhMUFx
    --  EFH/2gAIAQEAAT8Qn3igmSZSj+c4N4zapMy9IjFV98wncN2iuLFsCEbDGxQkI6RO/n//2Q==
    --  
    --  --------------A940F1230E6F0105F03DB2CB--
    --  
    --  --------------DB171738719FB06D67DEBAA0--
    --  

    EXEC @hr = sp_OADestroy @mime
    EXEC @hr = sp_OADestroy @pTxt
    EXEC @hr = sp_OADestroy @mpRelated
    EXEC @hr = sp_OADestroy @pHtml
    EXEC @hr = sp_OADestroy @pJpg


END
GO