cross
New Foswiki release 2.1.6 is available with important security fixes.
Sourceforge foswiki email lists being discontinued. Subscribe to the new Foswiki announce and discuss lists at MailingLists
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 16 Jul 2018 - 06:11.

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