USP_DATAFORMTEMPLATE_VIEW_DESIGNATIONCMS

The load procedure used by the view dataform template "Microsite Donation Designation View"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter used to load the fields defined on the form.
@DATALOADED	bit	INOUT	Output parameter indicating whether or not data was actually loaded.
@VANITYNAME	nvarchar(512)	INOUT	Public name
@URL	nvarchar(max)	INOUT	URL
@CMSCHILDREN	nvarchar(max)	INOUT	Included designations
@STARTDATE	datetime	INOUT	Start date
@ENDDATE	datetime	INOUT	End date
@ISACTIVE	bit	INOUT	Active
@CMS	bit	INOUT	Approved for website
@ISLIVE	bit	INOUT	Live on website
@SITEPAGESID	int	INOUT	Site Page ID

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_DESIGNATIONCMS
                (
                    @ID uniqueidentifier,
                    @DATALOADED bit = 0 output,
                    @VANITYNAME nvarchar(512) = null output,
                    @URL nvarchar(max) = null output,
                    @CMSCHILDREN nvarchar(max) = null output,
            @STARTDATE datetime = null output,
                    @ENDDATE datetime = null output,
            @ISACTIVE bit = null output, 
            @CMS bit = null output,
            @ISLIVE bit = null output,
            @SITEPAGESID int = null output
                )
                as
                    set nocount on;

            exec dbo.USP_DESIGNATIONCMS_VIEWDATA @ID, @DATALOADED output, @VANITYNAME output, @URL output, @CMSCHILDREN output, @STARTDATE output, @ENDDATE output, @ISACTIVE output, @CMS output, @ISLIVE output, @SITEPAGESID output;

                    return 0;