...
All functions without the parameter disableCommit=false
will not be auto commit after the function has executed.
...
Parameter | Description | ||
---|---|---|---|
| SQL string containing one or more parameter placeholders ('?'). | ||
| Value(s) to bind against parameter placeholders. | ||
| Name of the database profile(s) to use for access. | ||
| An optional parameter to disable the commit statement from being performed at the end of every SQL transaction for this particular function. Setting this parameter to false will result in the commit statement to be performed at the end of every SQL transaction for this particular function. By default, the system has the disableCommit set to true unless changed by this parameter.
| ||
Returns | Null in case of failure the error details can be found in System Log, otherwise a table, holding the SQL select result. |
...
Parameter | Description | |||||
---|---|---|---|---|---|---|
| SQL string containing one or more parameter placeholders ('?'). The string may also contain variables that substitute any part of the statement such as table- or column names.
| |||||
| Value(s) to bind against parameter placeholders | |||||
| Name of the database profile(s) to use for access | |||||
| An optional parameter to disable the commit statement from being performed at the end of every SQL transaction for this particular function. Setting this parameter to false will result in the commit statement to be performed at the end of every SQL transaction for this particular function. By default, the system has the disableCommit set to true unless otherwise changed via this parameter.
| |||||
Returns | Null in case of failure the error details can be found in System Log, otherwise a table, holding the SQL select result |
...
Parameter | Description |
---|---|
| SQL string containing one or more parameter placeholders ('?') |
| Value(s) to bind against parameter placeholders |
| Name of the database profile(s) to use for access |
Returns | -1 in case of failure the error details can be found in System Log, otherwise an integer equal to the number of rows updated or inserted |
...