SQL Server

Get the Filename of a Related Item

Demonstrates the Chilkat Email.GetRelatedFilename method, which returns the filename of a related item contained within the email. Related items are typically images and style sheets embedded within HTML emails, and the index is zero-based. This example adds a related style sheet and reads its filename.

Background: A related item's filename is how the HTML body refers to it — for example a style sheet named styles.css or an image named logo.png. When unpacking or archiving an HTML email, this filename is the natural name to write each embedded resource to on disk so the rewritten HTML links continue to resolve.

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 GetRelatedFilename method, which returns the filename of a related item
    --  contained within the email.  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', 'GetRelatedFilename example'

    --  The HTML references a related style sheet by name (Content-Location).
    EXEC sp_OAMethod @email, 'SetHtmlBody', NULL, '<html><head><link rel="stylesheet" href="styles.css"/></head><body>Styled.</body></html>'

    --  Add the related style sheet (index 0).
    EXEC sp_OAMethod @email, 'AddRelatedString2', NULL, 'styles.css', 'body { color: navy; }', 'utf-8'

    --  Read the filename of the first related item (index 0).
    DECLARE @fname nvarchar(4000)
    EXEC sp_OAMethod @email, 'GetRelatedFilename', @fname OUT, 0

    PRINT 'Related item 0 filename: ' + @fname

    EXEC @hr = sp_OADestroy @email


END
GO