USP_ADDUPDATE_SITECONTENTFOLDERS

Updates the categories/folders associated with a CMS Part

Parameters

Parameter	Parameter Type	Mode	Description
@ContentID	int	IN
@Categories	ntext	IN

Definition

Copy



create procedure [dbo].[USP_ADDUPDATE_SITECONTENTFOLDERS]
                (
                    @ContentID int,
                    @Categories ntext
                )
                AS
                    set nocount on;
                    DECLARE @Doc int;

                    BEGIN TRANSACTION USP_ADDUPDATE_SITECONTENTFOLDERS;

                    EXEC sp_xml_preparedocument @Doc OUTPUT, @Categories;

                    DELETE FROM dbo.SITECONTENTFOLDERS WHERE ContentID = @ContentID;

                    INSERT INTO dbo.SITECONTENTFOLDERS(ContentID, SiteFoldersID)
                        SELECT @ContentID, SiteFoldersID 
                        FROM OPENXML(@Doc, 'SiteContent/Category', 1)
                        WITH (ContentID integer, SiteFoldersID integer)
                        WHERE SiteFoldersID > 0;

                    EXEC sp_xml_removedocument @Doc;

                    COMMIT TRANSACTION USP_ADDUPDATE_SITECONTENTFOLDERS;