API UpdateArticle: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
 
Řádka 29: Řádka 29:
 
|-
 
|-
 
|@HtmlText
 
|@HtmlText
|ntext
+
|nvarchar(max)
 
|
 
|
 
|Html text
 
|Html text
Řádka 52: Řádka 52:
 
  DECLARE @Title nvarchar(50)
 
  DECLARE @Title nvarchar(50)
 
  DECLARE @UrlName nvarchar(50)
 
  DECLARE @UrlName nvarchar(50)
  DECLARE @HtmlText ntext
+
  DECLARE @HtmlText nvarchar(max)
 
  DECLARE @Language int
 
  DECLARE @Language int
 
   
 
   

Aktuální verze z 9. 11. 2018, 12:19

Description

Method allows You to update article in system.

Exact name

API_UpdateArticle

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@ID int Internal system id
@Title nvarchar(50) Title
@HtmlText nvarchar(max) Html text
@Language int Language.

cs=0; pl=1; en=2; de=3; sk=4; hu=5; ar=11; bg=17

Return

0 : OK
100 : Item could not be updated

Example

 DECLARE @return_value int
 DECLARE @ID int 
 DECLARE @Title nvarchar(50)
 DECLARE @UrlName nvarchar(50)
 DECLARE @HtmlText nvarchar(max)
 DECLARE @Language int
 
 SELECT @ID = [ID], 
       @Title= 'Title 2', 
       @HtmlText = [HtmlText], 
       @Language = [Language]
 FROM   [API_GetArticles] 
 WHERE  id = 3
 
 EXECUTE @return_value = [API_UpdateArticle] 
  @ID, 
  @Title, 
  @HtmlText,
  @Language

Notices

None.