SQL Server

Get the Entire Serialized MIME Body

Demonstrates the Chilkat Mime.GetEntireBody method, which returns the complete serialized body of the current entity. It takes no arguments. For multipart MIME this includes the boundary delimiters and each child part's headers and body.

Note: The file paths are relative to the application's current working directory. Absolute paths may also be used. Supply the paths appropriate to your own environment.

Background: This returns everything below the entity's own headers — for a simple part, just the body; for a multipart, the whole nested structure with its boundaries and child headers. It pairs with GetEntireHead, which returns the header section, so together they let you inspect or reconstruct a message's two halves separately.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

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

    EXEC sp_OAMethod @mime, 'LoadMimeFile', @success OUT, 'qa_data/message.eml'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mime, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mime
        RETURN
      END

    --  Return the complete serialized body of the current entity.  For multipart MIME, this includes
    --  the boundary delimiters and each child part's headers and body, but not the entity's own top
    --  headers.
    DECLARE @entireBody nvarchar(4000)
    EXEC sp_OAMethod @mime, 'GetEntireBody', @entireBody OUT
    EXEC sp_OAGetProperty @mime, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        EXEC sp_OAGetProperty @mime, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mime
        RETURN
      END

    PRINT @entireBody

    EXEC @hr = sp_OADestroy @mime


END
GO