SQL Server

Get a Related Item as Text with CRLF Line Endings

Demonstrates the Chilkat Email.GetRelatedStringCrLf method, which returns the text of a related item with CRLF (\r\n) line-endings, interpreting the item's bytes using the supplied charset. It is intended for text-based related items such as style sheets. This example reads an embedded CSS style sheet with normalized CRLF line endings.

Background: Embedded text may arrive with any style of line ending — bare LF, bare CR, or CRLF. This method normalizes them all to CRLF, which is what internet protocols and many Windows tools expect, avoiding mixed-newline problems when the text is written out or re-transmitted. It is the CRLF counterpart to GetRelatedString (which uses bare CR).

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 GetRelatedStringCrLf method, which returns the text of a related item
    --  with CRLF line-endings, interpreting the bytes using the specified charset.  This is
    --  intended for text-based related items such as style sheets.  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', 'GetRelatedStringCrLf 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; }' + CHAR(10) + 'h1 { color: teal; }', 'utf-8'

    --  Get the first related item (index 0) as text with CRLF line endings.
    DECLARE @content nvarchar(4000)
    EXEC sp_OAMethod @email, 'GetRelatedStringCrLf', @content OUT, 0, 'utf-8'

    PRINT 'Related item 0 text (CRLF-normalized):'

    PRINT @content

    EXEC @hr = sp_OADestroy @email


END
GO