This function executes an SQL statement a on the database being represented by alias b. Placeholders in the form of &parameterNumber being defined in the statement are replaced by the values of parameters c to j. Characters that are needed for a valid syntax need to be placed in the statement. There is no limit of the resultset being retrieved. If a limit is needed it has to be set using the LIMIT clause in the SQL statement.

The result set will be written to a map with name l. The value of each row's first column is used as the key, all remaining columns are concatenated together using the delimiter k and saved to the map using the key. The map will be cleared before values are added (can be suppressed with parameter o).

The return value of the function is the number of rows in the result set of the SQL query.

If there are columns of type BLOB in the result set, parameter m determines whether or not the binary data should be written to the result lists (entries in the map) in a Base64 format. If m is true, the function performs the encoding, false will leave the data unchanged. If there are no columns of type BLOB, the parameter has no effect.

Important note: In addition to the syntax &parameterNumber for parameters it is possible to use the syntax @parameterNumber:parameterType@ for prepared statements. The use of this prevents SQL Injection Attacks and should be preferred.