USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS

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

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN	The input ID parameter indicating the ID of the record being edited.
@CHANGEAGENTID	uniqueidentifier	IN	Input parameter indicating the ID of the change agent invoking the procedure.
@SEARCHRESULTHTML	nvarchar(max)	IN	Searchresulthtml
@SEARCHCRITERIADESIGNCODE	tinyint	IN	Searchcriteriadesign
@HTMLSEARCHRESULTCODE	tinyint	IN	Htmlsearchresult
@SHOWPAGINGCONTROLSCODE	tinyint	IN	Showpagingcontrols
@AUTOSEARCHENABLED	bit	IN	Autosearchenabled
@SEARCHCOLUMNS	int	IN	Searchcolumns
@SIMPLEFIELDSLIST	xml	IN	Simplefieldslist
@ADVANCEDFIELDSLIST	xml	IN	Advancedfieldslist
@OUTPUTFIELDSLIST	xml	IN	Outputfieldslist
@RECORDSPERPAGE	int	IN	Recordsperpage
@COLUMNSPERPAGE	int	IN	Columnsperpage
@RESULTSPERSESSION	int	IN	Resultspersession
@QUERYVIEWID	uniqueidentifier	IN	Queryviewid
@QUERYID	uniqueidentifier	IN	Queryid
@SPONSORSHIPFORMPAGEID	int	IN	SponsorshipFormPageId

Definition

Copy



CREATE procedure USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS
(
    @ID uniqueidentifier,
    @CHANGEAGENTID uniqueidentifier = null,
    @SEARCHRESULTHTML nvarchar(max),
    @SEARCHCRITERIADESIGNCODE tinyint,
    @HTMLSEARCHRESULTCODE tinyint,
    @SHOWPAGINGCONTROLSCODE tinyint,
    @AUTOSEARCHENABLED bit,
    @SEARCHCOLUMNS int,
    @SIMPLEFIELDSLIST xml,
    @ADVANCEDFIELDSLIST xml,
    @OUTPUTFIELDSLIST xml,
    @RECORDSPERPAGE int,
    @COLUMNSPERPAGE int,
    @RESULTSPERSESSION int,
    @QUERYVIEWID uniqueidentifier,
    @QUERYID uniqueidentifier,
    @SPONSORSHIPFORMPAGEID int
)

as
  set nocount on;

    declare @RESULTSFROMQUERY int;

  exec dbo.USP_DATAFORMTEMPLATE_EDITLOAD_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS
        @ID = @ID,
        @RESULTSFROMQUERY = @RESULTSFROMQUERY output

  exec dbo.USP_DATAFORMTEMPLATE_EDIT_SPONSORSHIPOPPORTUNITYSEARCHCMSSETTINGS_2
        @ID,
        @CHANGEAGENTID,
        @SEARCHRESULTHTML,
        @SEARCHCRITERIADESIGNCODE,
        @HTMLSEARCHRESULTCODE,
        @SHOWPAGINGCONTROLSCODE,
        @AUTOSEARCHENABLED,
        @SEARCHCOLUMNS,
        @SIMPLEFIELDSLIST,
        @ADVANCEDFIELDSLIST,
        @OUTPUTFIELDSLIST,
        @RECORDSPERPAGE,
        @COLUMNSPERPAGE,
        @RESULTSPERSESSION,
        @QUERYVIEWID,
        @QUERYID,
        @SPONSORSHIPFORMPAGEID,
        @RESULTSFROMQUERY

  return 0;