Help/SqlResultPlugin
Note: You are viewing an old revision of this page. View the current version.
The SqlResult plugin displays results of arbitrary SQL select statements in table form.
The database definition, the DSN, must be defined in the local file config/SqlResult.ini
A simple textfile with alias = dsn lines.
Optional template file to format the result and handle some logic.
Template vars: %%where%%, %%sortby%%, %%limit%%
Usage
<<SqlResult parameters SELECT statement >>
Arguments
Argument |
Description |
Default value |
|---|---|---|
alias |
DSN database specification |
false |
ordered |
if to display as <ol> list: single col only without template |
false |
template |
use a custom <theme>/template.tmpl |
false |
where |
custom filter for the query |
false |
sortby |
for paging |
false (no paging) |
limit |
for paging |
0,50 (only the first 50) |
Examples
<<SqlResult alias=mysql
SELECT 'mysql password for string "xx":',
PASSWORD('xx')
>>
<<SqlResult alias=videos template=videos
SELECT rating,title,date
FROM video
ORDER BY rating DESC
LIMIT 5
>>
<<SqlResult alias=imdb template=imdbmovies where||="Davies, Jeremy%"
SELECT m.title, m.date, n.name, c.role
FROM movies as m, names as n, jobs as j, characters as c
WHERE n.name LIKE "%%where%%"
AND m.title_id = c.title_id
AND n.name_id = c.name_id
AND c.job_id = j.job_id
AND j.description = 'Actor'
ORDER BY m.date DESC
>>
