SQL Server

Get the Value of a MIME Header Field

See more MIME Examples

Demonstrates how to get the value of a MIME header field. If the header field is not in the top-level MIME header, we must first navigate to the correct MIME part. 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
    --  

    --  Getting the content of a top-level MIME header is easy.
    --  MIME header fields are case insensitive.

    EXEC sp_OAMethod @mime, 'GetHeaderField', @sTmp0 OUT, 'subject'
    PRINT 'Subject = ' + @sTmp0

    EXEC sp_OAMethod @mime, 'GetHeaderField', @sTmp0 OUT, 'mime-version'
    PRINT 'MIME-Version = ' + @sTmp0

    --  To get a MIME header in a sub-part, first navigate to it..

    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 @mpRelated
        RETURN
      END

    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 @mpRelated
        EXEC @hr = sp_OADestroy @pJpg
        RETURN
      END


    EXEC sp_OAMethod @pJpg, 'GetHeaderField', @sTmp0 OUT, 'content-id'
    PRINT 'JPG Content-ID = ' + @sTmp0

    EXEC sp_OAMethod @pJpg, 'GetHeaderField', @sTmp0 OUT, 'content-type'
    PRINT 'JPG Content-Type = ' + @sTmp0

    --  --------------------------------------------------------------
    --  --------------------------------------------------------------
    --  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 @mpRelated
    EXEC @hr = sp_OADestroy @pJpg


END
GO