Help/SqlResultPlugin

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
>>

Author

See Also