API CreateSelectedCategory

Z Podpora.nextis.cz
Přejít na: navigace, hledání

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 text URL
@Image Image 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.