Plain Black, makers of WebGUI

View
Edit

^SQL();
A one line SQL report. Sometimes you just need to pull something back from the database quickly. This macro is also useful in extending the SQL Report wobject. It uses the numeric macros (^0; ^1; ^2; etc) to position data and can also use the ^^rownum; macro just like the SQL Report wobject.

Examples:

^SQL("select count(*) from users","There are ^0; users on this system.");

^SQL("select userId,username from users order by username","<a href='^/;?op=viewProfile&uid=^0;'>^1;</a><br />");

If there are more numeric macros than selected columns in the SQL report the extra macros will be discarded.

The rownum macro, ^rownum;, begins counting at 1.

This Macro may be nested inside other Macros if the text returned does not contain commas or quotes.

Note: that macro is not enabled by default and should be manually enabled in /data/WebGUI/etc/xxx.conf by adding "SQL" : "SQL" line to "macros" area.

Another Example:

^SQL("select p.fieldName, v.value from metaData_values v, metaData_properties p where p.fieldId = v.fieldId and v.assetId = '<tmpl_var assetId>' order by p.fieldName","<b>^0;</b> ^1;<br/>");

Output:

Author First Name Barbara
Author Last Name Nussbaum
Publication Date 03/16/06
Publication Type Merchants Of Vision

Keywords:

Title
Attachment(s)
Content	<p><strong>^SQL();</strong><br />A one line SQL report. Sometimes you just need to pull something back from the database quickly. This macro is also useful in extending the SQL Report wobject. It uses the numeric macros (^0; ^1; ^2; etc) to position data and can also use the ^^rownum; macro just like the SQL Report wobject.</p> <p>Examples:</p> <p>^SQL("select count(*) from users","There are ^0; users on this system."); </p> <p>^SQL("select userId,username from users order by username","<a href='^/;?op=viewProfile&uid=^0;'>^1;</a><br />"); </p> <p>If there are more numeric macros than selected columns in the SQL report the extra macros will be discarded.</p> <p>The rownum macro, ^rownum;, begins counting at 1.</p> <p>This Macro may be nested inside other Macros if the text returned does not contain commas or quotes.</p> <p>Note: that macro is not enabled by default and should be manually enabled in  /data/WebGUI/etc/xxx.conf by adding  "SQL" : "SQL" line to "macros"  area. </p> <p> </p> <p>Another Example:</p> <p>^SQL("select p.fieldName, v.value from metaData_values v, metaData_properties p where p.fieldId = v.fieldId and v.assetId = '<tmpl_var assetId>' order by p.fieldName","<b>^0;</b> ^1;<br/>");</p> <p>Output:</p> <p><strong>Author First Name</strong> Barbara<br /><strong>Author Last Name</strong> Nussbaum<br /><strong>Publication Date</strong> 03/16/06<br /><strong>Publication Type</strong> Merchants Of Vision</p>
Keywords

SQL Macro