You are here: Foswiki>Support Web>SupportQuestions>Question1200 (12 Nov 2012, FrankHoellering)Edit Attach
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
Edit  | Attach | Print version | History: r1 | Backlinks | View wiki text | Edit wiki text | More topic actions
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