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 - This page was cached on 10 Jan 2018 - 03:30.

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