USP_DATAFORMTEMPLATE_VIEW_SITEIMAGE

The load procedure used by the view dataform template "Image View Form"

Parameters

Parameter	Parameter Type	Mode	Description
@ID	int	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.
@NAME	nvarchar(256)	INOUT	Name
@IMAGETYPE	nvarchar(50)	INOUT	Type
@IMAGECONTENT	varbinary	INOUT	IMAGECONTENT
@LASTMODIFIED	datetime	INOUT	Last modified

Definition

Copy


CREATE procedure dbo.[USP_DATAFORMTEMPLATE_VIEW_SITEIMAGE]
(
  @ID int,
  @DATALOADED bit = 0 output,
  @NAME nvarchar(256) = null output,
  @IMAGETYPE nvarchar(50) = null output,
  @IMAGECONTENT varbinary(max) = null output,
  @LASTMODIFIED datetime = null output
)
as
  set nocount on;

  set @DATALOADED = 0;

  select 
    @DATALOADED = 1,
    @NAME = NAME,
    @IMAGETYPE = IMAGETYPE,
    @IMAGECONTENT = IMAGECONTENT,
    @LASTMODIFIED = dbo.fnLastModifiedDate(GUID)
  from dbo.SITEIMAGES
  where ID = @ID

    return 0;