This question about Documentation: Asked

Enhance Documentation about SQLFORMAT

The documentation of SQLFORMAT should contain an important point about the interaction between %SQL{}% and %SQLFORMAT{}% when using continue="on".

What I think I've learned from reviewing the source code is that in case you want to reuse the result in %SQLFORMAT{}% you have to specify a format="" attribute in the %SQL{}% statement, otherwise the resultset is consumed in %SQL{}% (or at leaset the first row, even with a limit="-1") and nothing or an incomplete resultset is available in %SQLFORMAT{}%.

-- FrankHoellering - 12 Nov 2012


QuestionForm edit

Subject Documentation
Extension SqlPlugin
Version Foswiki 1.1.3
Status Asked
Related Topics
Topic revision: r1 - 12 Nov 2012, FrankHoellering
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