...
| Info | ||
|---|---|---|
| ||
If data from the query contains embedded commas or colons, more care is required in the scripts to provide the appropriate quoting of the values. |
| No Format | ||
|---|---|---|
| ||
{run:id=dynamic|autorun=true|replace=report:2010::select::2010:Report 2010:2009:Report 2009:2008:Report 2008:2007:Report 2007:}
{sql-query:datasource=testDS}
select * from reports where year = $report
{sql-query}
{run}
|