DbExec: Difference between revisions
Jump to navigation
Jump to search
OpenIDUser32 (talk | contribs) No edit summary |
|||
| Line 31: | Line 31: | ||
This example shows how to use '''??''' for parts of the query that are not column values: | This example shows how to use '''??''' for parts of the query that are not column values: | ||
<syntaxhighlight lang="lua"> | <syntaxhighlight lang="lua"> | ||
dbExec( connection, " | dbExec( connection, "UPDATE ?? SET ??=?", tableName, columnName, columnValue ) | ||
</syntaxhighlight> | </syntaxhighlight> | ||
Revision as of 12:08, 23 December 2011
Available only in MTA SA 1.1.1 r3341 and onwards 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