DatabasePlugin format issues

I am having format issues. Any help is greatly appreciated.

%DATABASE_SQL{description="conn1" sql="select col1,col2 from schema.table where col3='Y' and col4='Y' order by 1" format="|*$COL1*|*$COL2*|" header="|*col1*|*col2*|"}%

The format string is not properly being translated. It resolves as %CALC%7B.

If I run just the format string separately, it resolves properly but does not work with the DATABASE_SQL Macro.

Thanks

I don't know if it will help, but I've been struggling to get going with DATABASE plugin. SQL plugin seems to be much more stable and it worked easier. Try SQL plugin instead of DATABASE plugin.

-- HenroRitchie - 26 Apr 2012