This question about Using an extension: Answered but needs rewriting

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.


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

QuestionForm edit

Subject Using an extension
Extension DatabasePlugin
Version Foswiki 1.0.9
Status Answered but needs rewriting
Related Topics
Topic revision: r2 - 26 Apr 2012, HenroRitchie - This page was cached on 14 Nov 2018 - 05:51.

The copyright of the content on this website is held by the contributing authors, except where stated elsewhere. See Copyright Statement. Creative Commons License    Legal Imprint    Privacy Policy