query_res function - Exportizer Documentation

Category:

Database related

General

Returns result of the one-field query, specified by SQL text.

Syntax

query_res(
  StepNo Integer,
  SqlText String
): <FieldType>

Parameters

StepNo specifies the export step, in which the function must be calculated. It is used in HTML export context only; in other cases this parameter is ignored.

SqlText is the text of the SQL query to execute.

Return value

Type: <FieldType> (depends on the database field type).

Examples of using

query_res(1, 'SELECT name FROM countries WHERE id = 1')