.executeSQLStatement()

Previous Next

Executes a SQL statement.

Returns the 'this' object.

Syntax

.executeSQLStatement( sql-statement, options )

 

options  :=  {

    hostvars:  hostvars

,   async:  async

,   hostvars:  hostvars

,   success:  success-function

,   error:  error-function

}

 

async   :=  { true | false }

 

The required sql-statement identifies the SQL statement to be executed.

Options is a struct that can have the following items, all of which are optional.

Hostvars is a struct containing name-value pairs that specify input values for the SQL statement.

Async is a boolean determining whether the operation is executed asynchronously. The default is false, meaning that the operation is executed synchronously by default.

Success-function is a function called after the operation has successfully completed.

Error-function is a function called if an error occurs.

 

Example

$.udb.executeSQLStatement( 'MySQL', {hostvars: {ID:'NL01234'}, async:true} );

 

 

See Also

SQL Statements