SQL Server

Get a Header Field of an Attachment

Demonstrates the Chilkat Email.GetAttachmentHeader method, which returns the value of a named header field of an attachment. The first argument is the zero-based attachment index and the second is the MIME header-field name. This example reads the Content-Disposition header of the first attachment.

Background: Each attachment is a MIME part with its own header block. Where GetAttachmentAttr extracts a single named parameter, GetAttachmentHeader returns the entire value of a header field — for example the full Content-Disposition: attachment; filename="notes.txt" line. That is useful for inspecting or debugging exactly how a part is described, including any custom X- headers a sender may have added.

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
    --  Demonstrates the GetAttachmentHeader method, which returns the value of a header field
    --  (by name) of an attachment.  The first argument is the zero-based attachment index and the second is the
    --  MIME header-field name.

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

    EXEC sp_OASetProperty @email, 'Subject', 'Attachment header field'

    DECLARE @success int
    EXEC sp_OAMethod @email, 'AddStringAttachment', @success OUT, 'notes.txt', 'Some notes.'

    --  Get the Content-Disposition header of the first attachment (index 0).
    DECLARE @disp nvarchar(4000)
    EXEC sp_OAMethod @email, 'GetAttachmentHeader', @disp OUT, 0, 'Content-Disposition'

    PRINT 'Attachment 0 Content-Disposition: ' + @disp

    EXEC @hr = sp_OADestroy @email


END
GO