Function: nornix_site.update_page_resource

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

Update page resource data

CREATE DEFINER=`root`@`localhost` FUNCTION `update_page_resource`(vMimeTypeNo INTEGER, vName
VARCHAR(80),
 vData LONGBLOB, vDescription VARCHAR(255), vWidth INTEGER, vHeight INTEGER, vDocumentNo INTEGER)
RETURNS int(11)
    MODIFIES SQL DATA
    COMMENT 'Update page resource data'
BEGIN
 UPDATE pageresource r SET `Data` = vData, Description = vDescription, TS = NULL, `Width` = vWidth,
`Height` = vHeight
 WHERE r.DocumentNo = vDocumentNo AND r.MimeTypeNo = vMimeTypeNo AND r.Name = vName;
 RETURN 1;
END