API UpdateArticle - Historie editací

Chrzaszcz v 9. 11. 2018, 11:19

2018-11-09T11:19:51Z

← Starší verze		Verze z 9. 11. 2018, 11:19
Řádek 29:		Řádek 29:
	\|-		\|-
	\|@HtmlText		\|@HtmlText
	\|~~ntext~~		\|nvarchar(max)
	\|		\|
	\|Html text		\|Html text
Řádek 52:		Řádek 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

Chrzaszcz v 21. 9. 2017, 10:46

2017-09-21T10:46:54Z

← Starší verze		Verze z 21. 9. 2017, 10:46
Řádek 42:		Řádek 42:
	\|}		\|}

			==== Return ====
			0 : OK
			100 : Item could not be updated

	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
			DECLARE @return_value int
	DECLARE @ID int		DECLARE @ID int
	DECLARE @Title nvarchar(50)		DECLARE @Title nvarchar(50)
Řádek 58:		Řádek 62:
	WHERE id = 3		WHERE id = 3

	EXECUTE [API_UpdateArticle]		EXECUTE @return_value = [API_UpdateArticle]
	@ID,		@ID,
	@Title,		@Title,

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update article in system. ==== Exact name ==== `API_UpdateArticle` ==== Type ==== Standard executab…“

2017-08-02T13:43:25Z

Založena nová stránka s textem „==== Description ==== Method allows You to update article in system. ==== Exact name ==== <code>API_UpdateArticle</code> ==== Type ==== Standard executab…“

Nová stránka

==== Description ====
Method allows You to update article in system.

==== Exact name ====
<code>API_UpdateArticle</code>

==== Type ====
Standard executable stored procedure.

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@ID
|int
|
|Internal system id
|
|-
|@Title
|nvarchar(50)
|
|Title
|
|-
|@HtmlText
|ntext
|
|Html text
|
|-
|@Language
|int
|
|Language.
cs=0; pl=1; en=2; de=3; sk=4; hu=5; ar=11; bg=17
|
|}

==== Example ====
<syntaxhighlight lang="sql">
DECLARE @ID int
DECLARE @Title nvarchar(50)
DECLARE @UrlName nvarchar(50)
DECLARE @HtmlText ntext
DECLARE @Language int

SELECT @ID = [ID],
@Title= 'Title 2',
@HtmlText = [HtmlText],
@Language = [Language]
FROM [API_GetArticles]
WHERE id = 3

EXECUTE [API_UpdateArticle]
@ID,
@Title,
@HtmlText,
@Language

</syntaxhighlight>

==== Notices ====
None.

API UpdateArticle - Historie editací

Chrzaszcz v 9. 11. 2018, 11:19

Chrzaszcz v 21. 9. 2017, 10:46

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update article in system. ==== Exact name ==== API_UpdateArticle ==== Type ==== Standard executab…“

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to update article in system. ==== Exact name ==== `API_UpdateArticle` ==== Type ==== Standard executab…“