fnGetStyleSheetForPage

Return

Return Type
int

Parameters

Parameter	Parameter Type	Mode	Description
@TemplatePageID	int	IN
@LayoutID	int	IN

Definition

Copy




  CREATE FUNCTION [dbo].[fnGetStyleSheetForPage](@TemplatePageID int, @LayoutID int)
  RETURNS int AS 
  BEGIN

      DECLARE @SheetID  int

      if (@LayoutID > 0) 
          select @sheetid = stylesheetid from sitelayouts 
          where id=@Layoutid
      else
      begin

          select @sheetid = sl.stylesheetid 
          from sitepages sp inner join sitelayouts sl on sp.templateid = sl.id
          where sp.id=@TemplatePageID
      end

      return @SheetID
  END