This macro extends SQL.pm macro to execute query to an external database. You can also execute not-returning query like delete, insert and update.
It's forward compatible with SQL macro, so you can write something like this
^SQLExt("select count(*) from users","There are ^0; users on this system.");
If you have defined some databaseLink, you can use them too like this:
^SQLExt("select * from table1","^0;-^1;","asdfasdf")
where asdfasdf is the databaseLinkId.
The complete syntax of this macro is:
^SQLExt($sql_statement,[$format],[$databaseLink])
where
To install it copy SQLExt.pm into lib/WebGUI/Macro. Then open your site config file and add to the "macros" declaration
"SQLExt" : "SQLExt",
NOTE: I will update this shortly (next day or two) to have a Help module included.