select into map(a,b,[param &1 equals c], d,e, f,g,h,i,j], delimiter k, map l,m,n,o,p)

This function executes the SQL SELECT statement a on the database with the alias b. It replaces placeholders in the format &parameter_number in the statement with the values from parameters c through j. Any characters required for valid statement syntax (for example, quotation marks around string values) must already be present in the statement. The result set is not limited. If you need fewer rows, use a LIMIT clause in the SQL statement.

The result table is written to a map named l. The value of the first column serves as the key. The remaining columns in each result row are separated by the delimiter k and concatenated into a single string. This string is stored as the value under the key in the map. Before writing, the function clears the map unless parameter o suppresses this.

The return value of the function is the number of rows returned.

If the result set contains columns of type BLOB, parameter m determines whether binary data is Base64-encoded in the result lists (map entries). When m equals true, the function Base64-encodes the data. Otherwise, data remains unchanged. If the result set contains no such columns, this parameter has no effect.

IMPORTANT:

In addition to the &parameter_number syntax, you can also use the syntax for prepared statements in the form @parameter_number:parameter_type@. Prefer this syntax because it prevents SQL injection attacks. Within prepared statements, parameters replace only individual values. SQL syntax such as value lists for IN, table or column names, operators, sort orders, or complete SQL fragments cannot be passed through placeholders.

Parameters

Examples

Assume a table zipcodes containing postal codes for Germany (20,000 entries in this example).

The result is a map ZIPS containing 20,000 entries with the postal code as key and city and state as value. For example: {80336=Munich;Bavaria}.

Produces the map with only the entry shown above.

In the first two cases, produces the map with all Bavarian postal codes.