USP_DATAFORMTEMPLATE_VIEW_FAF_FUNDRAISING_ROLES_CONTENT

The load procedure used by the view dataform template "FAF Fundraising Roles Content View 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.
@REGISTRATIONPAGEID	int	INOUT	Registrationpage
@STARTACOMPANYTITLE	nvarchar(500)	INOUT	Startacompanytitle
@STARTACOMPANYDESCRIPTION	nvarchar(510)	INOUT	Startacompanydescription
@STARTACOMPANYIMAGEID	int	INOUT	Startacompanyimageid
@STARTATEAMTITLE	nvarchar(500)	INOUT	Startateamtitle
@STARTATEAMDESCRIPTION	nvarchar(510)	INOUT	Startateamdescription
@STARTATEAMTITLEIMAGEID	int	INOUT	Startateamtitleimageid
@STARTATEAMUNDERGROUPTITLE	nvarchar(500)	INOUT	Startateamundergrouptitle
@STARTATEAMUNDERGROUPDESCRIPTION	nvarchar(510)	INOUT	Startateamundergroupdescription
@STARTATEAMUNDERGROUPIMAGEID	int	INOUT	Startateamundergroupimageid
@STARTATEAMINDEPENDENTTITLE	nvarchar(500)	INOUT	Startateamindependenttitle
@STARTATEAMINDEPENDENTDESCRIPTION	nvarchar(510)	INOUT	Startateamindependentdescription
@STARTATEAMINDEPENDENTIMAGEID	int	INOUT	Startateamindependentimageid
@JOINATEAMTITLE	nvarchar(500)	INOUT	Joinateamtitle
@JOINATEAMDESCRIPTION	nvarchar(510)	INOUT	Joinateamdescription
@JOINATEAMTITLEIMAGEID	int	INOUT	Joinateamtitleimageid
@STARTAHOUSEHOLDTITLE	nvarchar(500)	INOUT	Startahouseholdtitle
@STARTAHOUSEHOLDDESCRIPTION	nvarchar(510)	INOUT	Startahouseholddescription
@STARTAHOUSEHOLDIMAGEID	int	INOUT	Startahouseholdimageid
@STARTAHOUSEHOLDUNDERCOMPANYTITLE	nvarchar(500)	INOUT	Startahouseholdundercompanytitle
@STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION	nvarchar(510)	INOUT	Startahouseholdundercompanydescription
@STARTAHOUSEHOLDUNDERCOMPANYIMAGEID	int	INOUT	Startahouseholdundercompanyimageid
@STARTAHOUSEHOLDUNDERTEAMTITLE	nvarchar(500)	INOUT	Startahouseholdunderteamtitle
@STARTAHOUSEHOLDUNDERTEAMDESCRIPTION	nvarchar(510)	INOUT	Startahouseholdunderteamdescription
@STARTAHOUSEHOLDUNDERTEAMIMAGEID	int	INOUT	Startahouseholdunderteamimageid
@STARTAHOUSEHOLDINDEPENDENTTITLE	nvarchar(500)	INOUT	Startahouseholdindependenttitle
@STARTAHOUSEHOLDINDEPENDENTDESCRIPTION	nvarchar(510)	INOUT	Startahouseholdindependentdescription
@STARTAHOUSEHOLDINDEPENDENTIMAGEID	int	INOUT	Startahouseholdindependentimageid
@JOINASINDIVIDUALTITLE	nvarchar(500)	INOUT	Joinasindividualtitle
@JOINASINDIVIDUALDESCRIPTION	nvarchar(510)	INOUT	Joinasindividualdescription
@JOINASINDIVIDUALIMAGEID	int	INOUT	Joinasindividualimageid
@JOINASINDIVIDUALUNDERCOMPANYTITLE	nvarchar(500)	INOUT	Joinasindividualundercompanytitle
@JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION	nvarchar(510)	INOUT	Joinasindividualundercompanydescription
@JOINASINDIVIDUALUNDERCOMPANYIMAGEID	int	INOUT	Joinasindividualundercompanyimageid
@JOINASINDIVIDUALPARTICIPANTTITLE	nvarchar(500)	INOUT	Joinasindividualparticipanttitle
@JOINASINDIVIDUALPARTICIPANTDESCRIPTION	nvarchar(510)	INOUT	Joinasindividualparticipantdescription
@JOINASINDIVIDUALPARTICIPANTIMAGEID	int	INOUT	Joinasindividualparticipantimageid

Definition

Copy



CREATE procedure dbo.USP_DATAFORMTEMPLATE_VIEW_FAF_FUNDRAISING_ROLES_CONTENT 
(
    @ID uniqueidentifier,
    @DATALOADED bit = 0 output,
    @REGISTRATIONPAGEID integer = null output,
    @STARTACOMPANYTITLE nvarchar(500) = null output,
    @STARTACOMPANYDESCRIPTION nvarchar(510) = null output,
    @STARTACOMPANYIMAGEID int = null output,
    @STARTATEAMTITLE nvarchar(500) = null output,
    @STARTATEAMDESCRIPTION nvarchar(510) = null output,
    @STARTATEAMTITLEIMAGEID int = null output,
    @STARTATEAMUNDERGROUPTITLE nvarchar(500) = null output,
    @STARTATEAMUNDERGROUPDESCRIPTION nvarchar(510) = null output,
    @STARTATEAMUNDERGROUPIMAGEID int = null output,
    @STARTATEAMINDEPENDENTTITLE nvarchar(500) = null output,
    @STARTATEAMINDEPENDENTDESCRIPTION nvarchar(510) = null output,
    @STARTATEAMINDEPENDENTIMAGEID int = null output,
    @JOINATEAMTITLE nvarchar(500) = null output,
    @JOINATEAMDESCRIPTION nvarchar(510) = null output,
    @JOINATEAMTITLEIMAGEID int = null output,
    @STARTAHOUSEHOLDTITLE nvarchar(500) = null output,
    @STARTAHOUSEHOLDDESCRIPTION nvarchar(510) = null output,
    @STARTAHOUSEHOLDIMAGEID int = null output,
    @STARTAHOUSEHOLDUNDERCOMPANYTITLE nvarchar(500) = null output,
    @STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION nvarchar(510) = null output,
    @STARTAHOUSEHOLDUNDERCOMPANYIMAGEID int = null output,
    @STARTAHOUSEHOLDUNDERTEAMTITLE nvarchar(500) = null output,
    @STARTAHOUSEHOLDUNDERTEAMDESCRIPTION nvarchar(510) = null output,
    @STARTAHOUSEHOLDUNDERTEAMIMAGEID int = null output,
    @STARTAHOUSEHOLDINDEPENDENTTITLE nvarchar(500) = null output,
    @STARTAHOUSEHOLDINDEPENDENTDESCRIPTION nvarchar(510) = null output,
    @STARTAHOUSEHOLDINDEPENDENTIMAGEID int = null output,
    @JOINASINDIVIDUALTITLE nvarchar(500) = null output,
    @JOINASINDIVIDUALDESCRIPTION nvarchar(510) = null output,
    @JOINASINDIVIDUALIMAGEID int = null output,
    @JOINASINDIVIDUALUNDERCOMPANYTITLE nvarchar(500) = null output,
    @JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION nvarchar(510) = null output,
    @JOINASINDIVIDUALUNDERCOMPANYIMAGEID int = null output,
    @JOINASINDIVIDUALPARTICIPANTTITLE nvarchar(500) = null output,
    @JOINASINDIVIDUALPARTICIPANTDESCRIPTION nvarchar(510) = null output,
    @JOINASINDIVIDUALPARTICIPANTIMAGEID int = null output
)
as
    set nocount on;

    -- be sure to set this, in case the select returns no rows

    set @DATALOADED = 0;

    -- populate the output parameters, which correspond to fields on the form.  Note that

    -- we set @DATALOADED = 1 to indicate that the load was successful.  Otherwise, the system

    -- will display a "no data loaded" message.

    select @DATALOADED = 1,
           @REGISTRATIONPAGEID = REGISTRATIONPAGEID, 
           @STARTACOMPANYTITLE = STARTACOMPANYTITLE, 
           @STARTACOMPANYDESCRIPTION = STARTACOMPANYDESCRIPTION, 
           @STARTACOMPANYIMAGEID = STARTACOMPANYIMAGEID, 
           @STARTATEAMTITLE = STARTATEAMTITLE, 
           @STARTATEAMDESCRIPTION = STARTATEAMDESCRIPTION, 
           @STARTATEAMTITLEIMAGEID = STARTATEAMTITLEIMAGEID, 
           @STARTATEAMUNDERGROUPTITLE = STARTATEAMUNDERGROUPTITLE, 
           @STARTATEAMUNDERGROUPDESCRIPTION = STARTATEAMUNDERGROUPDESCRIPTION, 
           @STARTATEAMUNDERGROUPIMAGEID = STARTATEAMUNDERGROUPIMAGEID, 
           @STARTATEAMINDEPENDENTTITLE = STARTATEAMINDEPENDENTTITLE, 
           @STARTATEAMINDEPENDENTDESCRIPTION = STARTATEAMINDEPENDENTDESCRIPTION, 
           @STARTATEAMINDEPENDENTIMAGEID = STARTATEAMINDEPENDENTIMAGEID, 
           @JOINATEAMTITLE = JOINATEAMTITLE, 
           @JOINATEAMDESCRIPTION = JOINATEAMDESCRIPTION, 
           @JOINATEAMTITLEIMAGEID = JOINATEAMTITLEIMAGEID, 
           @STARTAHOUSEHOLDTITLE = STARTAHOUSEHOLDTITLE, 
           @STARTAHOUSEHOLDDESCRIPTION = STARTAHOUSEHOLDDESCRIPTION, 
           @STARTAHOUSEHOLDIMAGEID = STARTAHOUSEHOLDIMAGEID, 
           @STARTAHOUSEHOLDUNDERCOMPANYTITLE = STARTAHOUSEHOLDUNDERCOMPANYTITLE, 
           @STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION = STARTAHOUSEHOLDUNDERCOMPANYDESCRIPTION, 
           @STARTAHOUSEHOLDUNDERCOMPANYIMAGEID = STARTAHOUSEHOLDUNDERCOMPANYIMAGEID, 
           @STARTAHOUSEHOLDUNDERTEAMTITLE = STARTAHOUSEHOLDUNDERTEAMTITLE, 
           @STARTAHOUSEHOLDUNDERTEAMDESCRIPTION = STARTAHOUSEHOLDUNDERTEAMDESCRIPTION, 
           @STARTAHOUSEHOLDUNDERTEAMIMAGEID = STARTAHOUSEHOLDUNDERTEAMIMAGEID, 
           @STARTAHOUSEHOLDINDEPENDENTTITLE = STARTAHOUSEHOLDINDEPENDENTTITLE, 
           @STARTAHOUSEHOLDINDEPENDENTDESCRIPTION = STARTAHOUSEHOLDINDEPENDENTDESCRIPTION, 
           @STARTAHOUSEHOLDINDEPENDENTIMAGEID = STARTAHOUSEHOLDINDEPENDENTIMAGEID, 
           @JOINASINDIVIDUALTITLE = JOINASINDIVIDUALTITLE, 
           @JOINASINDIVIDUALDESCRIPTION = JOINASINDIVIDUALDESCRIPTION, 
           @JOINASINDIVIDUALIMAGEID = JOINASINDIVIDUALIMAGEID, 
           @JOINASINDIVIDUALUNDERCOMPANYTITLE = JOINASINDIVIDUALUNDERCOMPANYTITLE, 
           @JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION = JOINASINDIVIDUALUNDERCOMPANYDESCRIPTION, 
           @JOINASINDIVIDUALUNDERCOMPANYIMAGEID = JOINASINDIVIDUALUNDERCOMPANYIMAGEID, 
           @JOINASINDIVIDUALPARTICIPANTTITLE = JOINASINDIVIDUALPARTICIPANTTITLE, 
           @JOINASINDIVIDUALPARTICIPANTDESCRIPTION = JOINASINDIVIDUALPARTICIPANTDESCRIPTION, 
           @JOINASINDIVIDUALPARTICIPANTIMAGEID = JOINASINDIVIDUALPARTICIPANTIMAGEID
    from dbo.FAFFUNDRAISINGROLESCONTENT
    where ID = @ID

    return 0;