Function: nornix_site.add_page_resource

Information
DTD identifierDeterministicData accessMode
int(11)NOMODIFIES SQL DATA

Code

Add page resource file, returns success (0/1)

CREATE DEFINER=`root`@`localhost` FUNCTION `add_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 'Add page resource file, returns success (0/1)'
BEGIN
 DECLARE vContentTypeNo INTEGER;
 DECLARE success INTEGER DEFAULT 1;
 DECLARE CONTINUE HANDLER FOR SQLSTATE '23000' SET success = 0;
 SELECT `ContentTypeNo` INTO vContentTypeNo FROM `nornix_system`.`mimetype` WHERE `No` =
vMimeTypeNo;
 INSERT INTO pageresource (`Name`, `DocumentNo`, `MimeTypeNo`, `Data`, `TS`, `Description`,
`ContentTypeNo`, `Width`, `Height`)
 VALUES (vName, vDocumentNo, vMimeTypeNo, vData, NULL, vDescription, vContentTypeNo, vWidth,
vHeight);
 RETURN success;
END