UFN_SITEFOLDER_VERIFYPARENT

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode
@PARENTID	int	IN
@TYPE	int	IN
@SITEID	int	IN

Definition

Copy



create function UFN_SITEFOLDER_VERIFYPARENT(@PARENTID int, @TYPE int, @SITEID int)
returns bit
as
begin
   declare @RETVAL bit = 0;
   if @PARENTID is null
      set @RETVAL = 1;
   else
      select @RETVAL = 1 FROM SiteFolders where FOLDERID = @PARENTID and TYPE=@TYPE and CLIENTSITESID = @SITEID;
   return @RETVAL
end;