USP_DATAFORMTEMPLATE_ADD_FAFVANITYURL

The save procedure used by the add dataform template "FAFVanityURL Add Data Form".

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	INOUT	The output parameter indicating the ID of the record added.
@REALMTYPEID	int	IN
@REALMID	int	IN
@CLIENTUSERID	int	IN
@PAGEID	int	IN
@TABID	int	IN
@VANITYURL	nvarchar(255)	IN
@TARGETURL	nvarchar(max)	IN
@CLIENTSITESID	int	IN

Definition

Copy


CREATE procedure dbo.USP_DATAFORMTEMPLATE_ADD_FAFVANITYURL
(
    @ID int output,
    @REALMTYPEID int = 7,
    @REALMID int,
    @CLIENTUSERID int,
    @PAGEID int,
    @TABID int = 1,
    @VANITYURL nvarchar(255),
    @TARGETURL nvarchar(max) =null,
    @CLIENTSITESID int
)
as

set nocount on;

begin try
    -- handle inserting the data
    insert into dbo.VANITYURL
        (REALMTYPEID, REALMID, CLIENTUSERID, PAGEID, TABID, VANITYURL, TARGETURL, CLIENTSITESID, DATECHANGED, DATEADDED)
    values
        (@REALMTYPEID, @REALMID, @CLIENTUSERID, @PAGEID, @TABID, @VANITYURL, @TARGETURL, @CLIENTSITESID, GetDate(), GetDate())
  SELECT @ID = @@Identity
end try

begin catch
    exec dbo.USP_RAISE_ERROR
    return 1
end catch

return 0