SQL Server

Get the Content-ID of a Related Item

Demonstrates the Chilkat Email.GetRelatedContentID method, which returns the Content-ID of a related item (typically an image or style sheet embedded within an HTML email). The index is zero-based. This example loads an image from a file into a BinData object, adds it as a related item with AddRelatedBd (capturing the generated Content-ID and referencing it from the HTML), then reads that Content-ID back.

Background: The Content-ID is the anchor that ties an inline resource to the HTML that displays it: the body references cid: plus the ID, and the matching related part carries that same Content-ID. Because an image is binary, it is loaded into a BinData object (here from a file) and added with AddRelatedBd. Reading the Content-ID back lets a program verify or rewrite those links — for example when relocating embedded images or converting a message for display outside a mail client.

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

    --  Demonstrates the GetRelatedContentID method, which returns the Content-ID of a related
    --  item.  Related items are typically images and style sheets embedded within HTML emails.
    --  The index is zero-based.

    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', 'GetRelatedContentID example'

    --  Load the image data from a file into a BinData object.
    DECLARE @bdImage int
    EXEC @hr = sp_OACreate 'Chilkat.BinData', @bdImage OUT

    EXEC sp_OAMethod @bdImage, 'LoadFile', @success OUT, 'qa_data/images/logo.png'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @bdImage, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @email
        EXEC @hr = sp_OADestroy @bdImage
        RETURN
      END

    --  Add the image as a related item from the BinData; capture its generated Content-ID.
    DECLARE @cid nvarchar(4000)
    EXEC sp_OAMethod @email, 'AddRelatedBd', @cid OUT, 'logo.png', @bdImage
    EXEC sp_OAGetProperty @email, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 = 0
      BEGIN
        EXEC sp_OAGetProperty @email, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @email
        EXEC @hr = sp_OADestroy @bdImage
        RETURN
      END

    --  Reference the related item in the HTML body by its Content-ID.
    DECLARE @sbHtml int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbHtml OUT

    EXEC sp_OAMethod @sbHtml, 'Append', @success OUT, '<html><body><img src="cid:PLACEHOLDER_CID"/></body></html>'
    DECLARE @numReplaced int
    EXEC sp_OAMethod @sbHtml, 'Replace', @numReplaced OUT, 'PLACEHOLDER_CID', @cid
    EXEC sp_OAMethod @sbHtml, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @email, 'SetHtmlBody', NULL, @sTmp0

    --  Read the Content-ID of the first related item (index 0).
    DECLARE @cid0 nvarchar(4000)
    EXEC sp_OAMethod @email, 'GetRelatedContentID', @cid0 OUT, 0

    PRINT 'Related item 0 Content-ID: ' + @cid0

    --  Note: The path "qa_data/images/logo.png" is a relative local filesystem path,
    --  relative to the current working directory of the running application.

    EXEC @hr = sp_OADestroy @email
    EXEC @hr = sp_OADestroy @bdImage
    EXEC @hr = sp_OADestroy @sbHtml


END
GO