USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS

The load procedure used by the edit dataform template "SponsorshipOpportunitySearchCMSSettings Edit Form"

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.
@TSLONG	bigint	INOUT	Output parameter indicating the TSLONG value of the record being edited. This is used to manage multi-user concurrency issues when multiple users access the same record.
@SEARCHRESULTHTML	nvarchar(max)	INOUT	Searchresulthtml
@SEARCHCRITERIADESIGNCODE	tinyint	INOUT	Searchcriteriadesign
@HTMLSEARCHRESULTCODE	tinyint	INOUT	Htmlsearchresult
@SHOWPAGINGCONTROLSCODE	tinyint	INOUT	Showpagingcontrols
@AUTOSEARCHENABLED	bit	INOUT	Autosearchenabled
@SEARCHCOLUMNS	int	INOUT	Searchcolumns
@SIMPLEFIELDSLIST	xml	INOUT	Simplefieldslist
@ADVANCEDFIELDSLIST	xml	INOUT	Advancedfieldslist
@OUTPUTFIELDSLIST	xml	INOUT	Outputfieldslist
@RECORDSPERPAGE	int	INOUT	Recordsperpage
@COLUMNSPERPAGE	int	INOUT	Columnsperpage
@RESULTSPERSESSION	int	INOUT	Resultspersession
@QUERYVIEWID	uniqueidentifier	INOUT	Queryviewid
@QUERYID	uniqueidentifier	INOUT	Queryid
@SPONSORSHIPFORMPAGEID	int	INOUT	SponsorshipFormPageId
@OPPORTUNITYMASKID	uniqueidentifier	INOUT	OpportunityMaskID
@RESULTSFROMQUERY	int	INOUT

Definition

Copy


            CREATE procedure dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS
            (
                @ID uniqueidentifier,
                @DATALOADED bit = 0 output,
                @TSLONG bigint = 0 output,
                @SEARCHRESULTHTML nvarchar(max) = null output,
                @SEARCHCRITERIADESIGNCODE tinyint = null output,
                @HTMLSEARCHRESULTCODE tinyint = null output,
                @SHOWPAGINGCONTROLSCODE tinyint = null output,
                @AUTOSEARCHENABLED bit = null output,
                @SEARCHCOLUMNS int = null output,
                @SIMPLEFIELDSLIST xml = null output,
                @ADVANCEDFIELDSLIST xml = null output,
                @OUTPUTFIELDSLIST xml = null output,
                @RECORDSPERPAGE int = null output,
                @COLUMNSPERPAGE int = null output,
                @RESULTSPERSESSION int = null output,
                @QUERYVIEWID uniqueidentifier = null output,
                @QUERYID uniqueidentifier = null output,
                @SPONSORSHIPFORMPAGEID int = null output,
                @OPPORTUNITYMASKID uniqueidentifier = null output,
                @RESULTSFROMQUERY int = null output
            )
            as

                set nocount on;

                set @DATALOADED = 0
                set @TSLONG = 0

                select
                  @DATALOADED = 1,
                  @TSLONG = soc.TSLONG,
                  @SEARCHRESULTHTML = SEARCHRESULTHTML, 
                  @SEARCHCRITERIADESIGNCODE = SEARCHCRITERIADESIGNCODE, 
                  @HTMLSEARCHRESULTCODE = HTMLSEARCHRESULTCODE, 
                  @SHOWPAGINGCONTROLSCODE = SHOWPAGINGCONTROLSCODE, 
                  @AUTOSEARCHENABLED = AUTOSEARCHENABLED, 
                  @SEARCHCOLUMNS = SEARCHCOLUMNS, 
                  @SIMPLEFIELDSLIST = SIMPLEFIELDSLIST, 
                  @ADVANCEDFIELDSLIST = ADVANCEDFIELDSLIST, 
                  @OUTPUTFIELDSLIST = OUTPUTFIELDSLIST, 
                  @RECORDSPERPAGE = RECORDSPERPAGE, 
                  @COLUMNSPERPAGE = COLUMNSPERPAGE, 
                  @RESULTSPERSESSION = RESULTSPERSESSION, 
                  @QUERYVIEWID = soc.QUERYVIEWID, 
                  @QUERYID = soc.QUERYID,
                  @SPONSORSHIPFORMPAGEID = SPONSORSHIPFORMPAGEID,
                  @OPPORTUNITYMASKID = soi.ID, 
                  @RESULTSFROMQUERY = RESULTSFROMQUERY
              from 
                  dbo.SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS soc 
                  left outer join dbo.SPONSORSHIPOPPORTUNITYSEARCHCMSMASKINGIMAGES soi on soc.ID = soi.SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGSID
              where soc.ID = @ID

                return 0;