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

DBI_CALL -- directly call a subquery.

%DBI_CALL{...}% directly calls a subquery and pass over optional named parameters simulating %DBI_SUBQUERY% call.

Parameters

Parameter Description Default Required
"subquery" Subquery to call. none required

Optional parameters are transfered to the subquery as if they are columns of a database record. Consider the following example:

%DBI_CALL{"example" uid="12"}%

%DBI_QUERY{"db_identifier" subquery="example"}%
SELECT
    name
  FROM
    Users
  WHERE
    id = %uid%
.header
....
%DBI_QUERY%

IDEA! Read more in Variable Expansion section.

Topic revision: r5 - 30 Mar 2017, CrawfordCurrie - This page was cached on 16 Aug 2018 - 17: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    Legal Imprint    Privacy Policy