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 18 Jan 2018 - 12:49.

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