# "UpdateHtmlText" Stored Procedure

Description:

This stored procedure is used by the HtmlModule edit page to apply changes to an existing HtmlText item. The input parameters include the item's primary key (ModuleID), plus Desktop HTML, Mobile Summary text and Mobile details text.

Definition:

       CREATE PROCEDURE Portal_UpdateHtmlText
       (
           @ModuleID      int,
           @DesktopHtml   ntext,
           @MobileSummary ntext,
           @MobileDetails ntext
       )
       AS

       IF NOT EXISTS (
           SELECT
               *
           FROM Portal_HtmlText
           WHERE
               ModuleID = @ModuleID
       )
       INSERT INTO Portal_HtmlText (
           ModuleID,
           DesktopHtml,
           MobileSummary,
           MobileDetails
       )
       VALUES (
           @ModuleID,
           @DesktopHtml,
           @MobileSummary,
           @MobileDetails
       )
       ELSE
       UPDATE Portal_HtmlText

       SET
           DesktopHtml   = @DesktopHtml,
           MobileSummary = @MobileSummary,
           MobileDetails = @MobileDetails

       WHERE
           ModuleID = @ModuleID

Database Tables Used:

HtmlText: Each record in the HtmlText holds the HTML and text associated with a specific Html module. Each of the text field - DesktopHtml, MobileSummary, and MobileDetails - is stored in a SQL Unicode text field, and can hold up to 1,073,741,823 characters.

The primary key in this table is the ModuleID field.