API CreateSelectedCategory - Historie editací

Chrzaszcz v 9. 11. 2018, 13:49

2018-11-09T13:49:23Z

← Starší verze		Verze z 9. 11. 2018, 13:49
Řádek 23:		Řádek 23:
	\|-		\|-
	\|@URL		\|@URL
	\|~~text~~		\|nvarchar(max)
	\|		\|
	\|URL		\|URL
Řádek 29:		Řádek 29:
	\|-		\|-
	\|@Image		\|@Image
	\|~~Image~~		\|varbinary(max)
	\|		\|
	\|Image		\|Image

Chrzaszcz v 21. 9. 2017, 10:51

2017-09-21T10:51:34Z

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

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

	==== Example ====		==== Example ====
	<syntaxhighlight lang="sql">		<syntaxhighlight lang="sql">
			DECLARE @return_value int
	Declare @img AS VARBINARY(MAX)		Declare @img AS VARBINARY(MAX)
	Select @img = CAST(bulkcolumn AS VARBINARY(MAX))		Select @img = CAST(bulkcolumn AS VARBINARY(MAX))
Řádek 63:		Řádek 68:
	SINGLE_BLOB ) AS x		SINGLE_BLOB ) AS x

	EXEC [API_CreateSelectedCategory] @Name= 'TestCategory3' ,@URL= 'http://nextis.cz' ,@Image= @img ,@ImageExt= '.png' ,@Language= 0 ,@OrderNumber= 1		EXEC @return_value = [API_CreateSelectedCategory] @Name= 'TestCategory3' ,@URL= 'http://nextis.cz' ,@Image= @img ,@ImageExt= '.png' ,@Language= 0 ,@OrderNumber= 1
	</syntaxhighlight>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.

Chrzaszcz v 2. 8. 2017, 13:19

2017-08-02T13:19:50Z

← Starší verze		Verze z 2. 8. 2017, 13:19
Řádek 17:		Řádek 17:
	\|-		\|-
	\|@Name		\|@Name
	\|~~int~~		\|nvarchar(255)
	\|		\|
	\|Name		\|Name

Chrzaszcz v 31. 7. 2017, 12:18

2017-07-31T12:18:07Z

← Starší verze		Verze z 31. 7. 2017, 12:18
Řádek 63:		Řádek 63:
	SINGLE_BLOB ) AS x		SINGLE_BLOB ) AS x

	EXEC [API_CreateSelectedCategory] @Name= 'TestCategory3' ,@URL= 'http://nextis.cz' ,@Image= @img ,@ImageExt= '.png' ,@~~Lang~~ = 0		EXEC [API_CreateSelectedCategory] @Name= 'TestCategory3' ,@URL= 'http://nextis.cz' ,@Image= @img ,@ImageExt= '.png' ,@Language= 0 ,@OrderNumber= 1
	</syntaxhighlight>		</syntaxhighlight>

	==== Notices ====		==== Notices ====
	None.		None.

Chrzaszcz v 31. 7. 2017, 11:43

2017-07-31T11:43:32Z

@@ Řádek 16: / Řádek 16: @@
 !Relation
 |-
-|@WorkshopID
+|@Name
 |int
+|
-|ID of workshop from workshop list (see relation)
+|Name
-|API_GetWorkshops.ID
 |}
 ==== Example ====
 <syntaxhighlight lang="sql">
-EXEC [API_CreateSelectedCategory] @WorkshopID = 1 ,@Name = 'Name' ,@Street = 'Street' ,@City = 'City' ,@ZIPCode = 'ZIPCode' ,@Country = 'Country' ,@Region = 'Region' ,@State ='Česká republika' ,@StateID = 15797 ,@Phone = '+420 556 621 300' ,@Fax = '+420 596 790 789' ,@MobilePhone = '+420 556 621 301' ,@Email = 'info@nextis.cz' ,@Web = 'www.nextis.cz'
+Declare @img AS VARBINARY(MAX)
 </syntaxhighlight>
 ==== Notices ====
 None.

Chrzaszcz: Založena nová stránka s textem „==== Description ==== Method allows You to create new selected category in system. ==== Exact name ==== `API_CreateSelectedCategory` ==== Type…“

2017-07-31T11:36:57Z

Založena nová stránka s textem „==== Description ==== Method allows You to create new selected category in system. ==== Exact name ==== <code>API_CreateSelectedCategory</code> ==== Type…“

Nová stránka

==== Description ====
Method allows You to create new selected category in system.

==== Exact name ====
<code>API_CreateSelectedCategory</code>

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

==== Specification ====
{| class="wikitable"
!Parameter
!Data type
!Value range
!Description
!Relation
|-
|@WorkshopID
|int
|
|ID of workshop from workshop list (see relation)
|API_GetWorkshops.ID
|}

==== Example ====
<syntaxhighlight lang="sql">
EXEC [API_CreateSelectedCategory] @WorkshopID = 1 ,@Name = 'Name' ,@Street = 'Street' ,@City = 'City' ,@ZIPCode = 'ZIPCode' ,@Country = 'Country' ,@Region = 'Region' ,@State ='Česká republika' ,@StateID = 15797 ,@Phone = '+420 556 621 300' ,@Fax = '+420 596 790 789' ,@MobilePhone = '+420 556 621 301' ,@Email = 'info@nextis.cz' ,@Web = 'www.nextis.cz'
</syntaxhighlight>

==== Notices ====
None.