This page is incomplete! Help wanted!

Please finish this page using the corresponding Old Wiki article.
Go to Contribution guidelines for more information.

---

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

Tip

The server command debugdb 2 will output verbose information on each query to a logging file (usually logs/db.log )

Syntax

 dbExec ( )

Code Examples

Example 1 Example 2 Example 3

server

This example executes an INSERT query:

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

server

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

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

server

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

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

See Also

Database Functions

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

Reference

• Scripting Functions