API CreateSelectedCategory: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
Řádka 17: Řádka 17:
 
|-
 
|-
 
|@Name
 
|@Name
|int
+
|nvarchar(255)
 
|
 
|
 
|Name
 
|Name

Verze z 2. 8. 2017, 15:19

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

Example

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

Notices

None.