Difference between revisions of "Help:Creating SQL-queries"
From Testiwiki
Juha Villman (talk | contribs) (created help-page) |
(categorised) |
||
Line 1: | Line 1: | ||
+ | [[Category:Open assessment]] | ||
+ | {{method}} | ||
It is possible to create SQL-queries as links to Result Database using '''sql-query''' -tag. | It is possible to create SQL-queries as links to Result Database using '''sql-query''' -tag. | ||
Revision as of 07:18, 29 November 2008
This page is a method.
The page identifier is Op_en2559 |
---|
Moderator:Nobody (see all) Click here to sign up. |
Give your opinion to the peer rating of the content of this page. |
Upload data
|
It is possible to create SQL-queries as links to Result Database using sql-query -tag.
Usage
Place your SQL-query between <sql-query> and </sql-query> -tags.
Example:
<sql-query>select * from Variable </sql-query>
Generates: <sql-query>select * from Variable </sql-query>
It is also possible use additional parameters:
- display (if set to "1" SQL-query is displayed in wikipage as preformatted text)
- name (name of the link, default is "Run query")
Example:
<sql-query display="1" name="What a great query">select * from Variable </sql-query>
Generates: <sql-query display="1" name="What a great query">select * from Variable </sql-query>
Note: Length of the query is limited to 255 characters