API CreateRecommendedLink: Porovnání verzí

Z Podpora.nextis.cz
Přejít na: navigace, hledání
(Založena nová stránka s textem „==== Description ==== Method allows You to create new recommended link in system. ==== Exact name ==== <code>API_CreateRecommendedLink</code> ==== Type =…“)
 
 
(Není zobrazena jedna mezilehlá verze od stejného uživatele.)
Řádka 16: Řádka 16:
 
!Relation
 
!Relation
 
|-
 
|-
|@WorkshopID
+
|@Name
|int
+
|nvarchar(35)
 +
|
 +
|Name
 +
|
 +
|-
 +
|@Description
 +
|nvarchar(200)
 +
|
 +
|Description
 +
|
 +
|-
 +
|@Url
 +
|nvarchar(500)
 +
|
 +
|Url
 +
|
 +
|-
 +
|@IsTargetBlank
 +
|bit
 +
|
 +
|Is target blank
 +
|
 +
|-
 +
|@RegisteredOnly
 +
|bit
 +
|
 +
|Registered only
 
|
 
|
|ID of workshop from workshop list (see relation)
 
|API_GetWorkshops.ID
 
 
|}
 
|}
 +
 +
==== Return ====
 +
0 : OK
 +
100 : Item could not be created
  
 
==== Example ====
 
==== Example ====
 
<syntaxhighlight lang="sql">
 
<syntaxhighlight lang="sql">
EXEC [API_CreateRecommendedLink] @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 @return_value int
 +
EXEC @return_value = [API_CreateRecommendedLink] @Name = 'Name' ,@Description= 'Description' ,@Url= 'https://nextis.cz' ,@IsTargetBlank= 0 ,@RegisteredOnly = 0
 
</syntaxhighlight>
 
</syntaxhighlight>
  
 
==== Notices ====
 
==== Notices ====
 
None.
 
None.

Aktuální verze z 21. 9. 2017, 12:49

Description

Method allows You to create new recommended link in system.

Exact name

API_CreateRecommendedLink

Type

Standard executable stored procedure.

Specification

Parameter Data type Value range Description Relation
@Name nvarchar(35) Name
@Description nvarchar(200) Description
@Url nvarchar(500) Url
@IsTargetBlank bit Is target blank
@RegisteredOnly bit Registered only

Return

0 : OK
100 : Item could not be created

Example

 DECLARE @return_value int
 EXEC @return_value = [API_CreateRecommendedLink] @Name = 'Name' ,@Description= 'Description' ,@Url= 'https://nextis.cz' ,@IsTargetBlank= 0 ,@RegisteredOnly = 0

Notices

None.