SQL Server

Check if a MIME Entity is multipart/mixed

Demonstrates the Chilkat Mime.IsMultipartMixed method, which returns whether the Content-Type is exactly multipart/mixed. It takes no arguments.

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

Background: multipart/mixed is the "body plus attachments" layout, so identifying it tells you the children are independent parts to be handled separately rather than competing renderings. It is the specific counterpart to the general IsMultipart.

Chilkat SQL Server Downloads

Download Chilkat for SQL Server

SQL Server

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

    --  Demonstrates the Mime.IsMultipartMixed method, which returns whether the Content-Type is multipart/mixed.  It takes no arguments.

    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/multipart_message.eml'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @mime, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @mime
        RETURN
      END

    EXEC sp_OAMethod @mime, 'IsMultipartMixed', @iTmp0 OUT
    IF @iTmp0
      BEGIN

        PRINT 'This is a multipart/mixed entity.'
      END
    ELSE
      BEGIN

        PRINT 'This is not multipart/mixed.'
      END

    EXEC @hr = sp_OADestroy @mime


END
GO