SQL Yoga version 1.1.0 build 4 :: Visit website

Printer friendly version

command dbconn_executeWBindings

Executes a SQL query using pValuesA as the binding array.

command dbconn_executeWBindings pSQL, @pBindingsA
Parameters
TypeNameDescription
Simple parameter. pSQL SQL to execute. Use placeholders (:1,:2) for binding.
Simple parameter. @pBindingsA Array of values to bind. Keyed using integers.
OptionalSimple parameter. [pConnName] The name of a Database Connection. The default is the "default connection" for the Database Object.
OptionalSimple parameter. [pDBKey] Database Object connection is associated with. Default is name returned by sqlyoga_getDefaultDatabase().
Return

Returns empty. Affected rows in 'it'. Any errors will be thrown: sqlyoga_executesql_err,ERROR