DbExec

This function executes a database query using the supplied connection. No result is returned.

Syntax

bool dbExec ( element databaseConnection, string query [, var param1 [, var param2 ...]] )

Required Arguments

• databaseConnection: A database connection element previously returned from dbConnect
• query: An SQL query. Positions where parameter values will be inserted are marked with a ?

Optional Arguments

• paramX: A variable number of parameters. These must be strings or numbers - it is important to make sure they are of the correct type. Also, the number of parameters passed must be equal to the number of ? characters in the query string.

String parameters are automatically quoted and escaped as required. (If you do not want a string quoted, use ??)

Returns

Returns true unless the connection is incorrect, in which case it returns false.

Example

This example executes an INSERT query:

dbExec( connection, "INSERT INTO table_name VALUES (?,?,?)", "aaa", "bbb", 10 )

This example shows how to use ?? for parts of the query that are not column values:

dbExec( connection, "UPDATE ?? SET ??=?", tableName, columnName, columnValue )

Requirements

This template will be deleted.

See Also

• executeSQLQuery
• dbConnect
• dbExec
• dbFree
• dbPoll
• dbPrepareString
• dbQuery