API CreateSelectedCategory

Description

Method allows You to create new selected category in system.

Exact name

API_CreateSelectedCategory

Type

Standard executable stored procedure.

Specification

Parameter	Data type	Value range	Description	Relation
@Name	nvarchar(255)		Name
@URL	nvarchar(max)		URL
@Image	varbinary(max)		Image
@ImageExt	nvarchar(5)		Image ext
@Language	int		Language cs=0; pl=1; en=2; de=3; sk=4; hu=5; ar=11; bg=17
@OrderNumber	int		Order number

Return

0 : OK
100 : Item could not be created

Example

DECLARE @return_value int
Declare @img AS VARBINARY(MAX)
Select @img = CAST(bulkcolumn AS VARBINARY(MAX))
 FROM OPENROWSET(
            BULK
            'C:\test.png',
            SINGLE_BLOB ) AS x
			
 EXEC @return_value = [API_CreateSelectedCategory] @Name= 'TestCategory3' ,@URL= 'http://nextis.cz' ,@Image= @img ,@ImageExt= '.png' ,@Language= 0 ,@OrderNumber= 1

Notices

None.