Sql.sql_util

Sql.sql_util.fallback()

Method Sql.sql_util.emulate_bindings()

Method emulate_bindings

string Sql.sql_util.emulate_bindings(string query, mapping(string|int:mixed)|void bindings, void|object driver)

Description

build a raw SQL query, given the cooked query and the variable bindings It's meant to be used as an emulation engine for those drivers not providing such a behaviour directly (i.e. Oracle). The raw query can contain some variables (identified by prefixing a colon to a name or a number(i.e. :var, :2). They will be replaced by the corresponding value in the mapping.

Parameter query

The query

Parameter bindings

Optional mapping containing the variable bindings. Make sure that no confusion is possible in the query. If necessary, change the variables' names.

Extracted from Pike v7.3 release 11 at 2001-11-03.