DbExec - Revision history

Fernando187 at 15:35, 7 November 2024

2024-11-07T15:35:23Z

← Older revision		Revision as of 15:35, 7 November 2024
Line 36:		Line 36:
	dbExec( connection, "UPDATE `??` SET `??`=?", tableName, columnName, columnValue )		dbExec( connection, "UPDATE `??` SET `??`=?", tableName, columnName, columnValue )
	</syntaxhighlight>		</syntaxhighlight>

	~~==Requirements==~~
	~~{{Requirements\|1.1.1-9.03341\|n/a}}~~

	==See Also==		==See Also==
	{{Registry_functions}}		{{Registry_functions}}

2022-07-30T14:21:49Z

Clarify what does "result" mean

← Older revision		Revision as of 14:21, 30 July 2022
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	{{Server function}}		{{Server function}}
	This function executes a database query using the supplied connection. No result is returned.		This function executes a database query using the supplied connection. No query result is returned.
	{{Tip\|The server command [[Server_Commands#debugdb\|debugdb 2]] will output verbose information on each query to a logging file (usually '''logs/db.log''')}}		{{Tip\|The server command [[Server_Commands#debugdb\|debugdb 2]] will output verbose information on each query to a logging file (usually '''logs/db.log''')}}
	==Syntax==		==Syntax==

2017-04-06T18:12:31Z

Added tip to prevent issues with numbers in queries.

← Older revision		Revision as of 18:12, 6 April 2017
Line 14:		Line 14:
	===Optional Arguments===		===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.		*'''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 '''??''')		String parameters are automatically quoted and escaped as required. (If you do not want a string quoted, use '''??''') Make sure that numbers are in number format as a string number is treated differently.

	===Returns===		===Returns===

2014-12-28T18:10:27Z

fix oop syntax

← Older revision		Revision as of 18:10, 28 December 2014
Line 7:		Line 7:
	bool dbExec ( element databaseConnection, string query [, var param1 [, var param2 ...]] )		bool dbExec ( element databaseConnection, string query [, var param1 [, var param2 ...]] )
	</syntaxhighlight>		</syntaxhighlight>
	{{OOP\|\|[[~~Connection~~]]:exec}}		{{OOP\|\|[[connection]]:exec}}
	===Required Arguments===		===Required Arguments===
	*'''databaseConnection:''' A database connection element previously returned from [[dbConnect]]		*'''databaseConnection:''' A database connection element previously returned from [[dbConnect]]

2014-12-27T00:02:38Z

← Older revision		Revision as of 00:02, 27 December 2014
Line 7:		Line 7:
	bool dbExec ( element databaseConnection, string query [, var param1 [, var param2 ...]] )		bool dbExec ( element databaseConnection, string query [, var param1 [, var param2 ...]] )
	</syntaxhighlight>		</syntaxhighlight>
			{{OOP\|\|[[Connection]]:exec}}
	===Required Arguments===		===Required Arguments===
	*'''databaseConnection:''' A database connection element previously returned from [[dbConnect]]		*'''databaseConnection:''' A database connection element previously returned from [[dbConnect]]

2012-09-01T05:44:44Z

← Older revision		Revision as of 05:44, 1 September 2012
Line 2:		Line 2:
	{{Server function}}		{{Server function}}
	This function executes a database query using the supplied connection. No result is returned.		This function executes a database query using the supplied connection. No result is returned.
			{{Tip\|The server command [[Server_Commands#debugdb\|debugdb 2]] will output verbose information on each query to a logging file (usually '''logs/db.log''')}}
	==Syntax==		==Syntax==
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">

2012-06-14T00:01:59Z

← Older revision		Revision as of 00:01, 14 June 2012
Line 29:		Line 29:
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">
	dbExec( connection, "UPDATE ?? SET ??=?", tableName, columnName, columnValue )		dbExec( connection, "UPDATE ?? SET ??=?", tableName, columnName, columnValue )
			</syntaxhighlight><br>
			'''''Note''': It is usually good practice to surround table and column names with backticks (`) in case they contain spaces or SQL keywords (and therefore cause syntax errors). This is especially true when using variables for table and column names, as potential problems may not be apparent when the script is first written.''<br>

			This example shows how to use backticks and '''??''' for parts of the query that are not column values:
			<syntaxhighlight lang="lua">
			dbExec( connection, "UPDATE `??` SET `??`=?", tableName, columnName, columnValue )
	</syntaxhighlight>		</syntaxhighlight>

2012-06-01T12:59:41Z

← Older revision		Revision as of 12:59, 1 June 2012
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	{{Server function}}		{{Server function}}
	~~{{New feature/item\|3.0120\|1.2\|3341\|~~
	~~'''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.		This function executes a database query using the supplied connection. No result is returned.

2011-12-23T12:08:08Z

Why SELECT query if dbExec can't return data

← Older revision		Revision as of 12:08, 23 December 2011
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, "~~SELECT * FROM~~ ?? ~~WHERE~~ ??=?", tableName, columnName, columnValue )		dbExec( connection, "UPDATE ?? SET ??=?", tableName, columnName, columnValue )
	</syntaxhighlight>		</syntaxhighlight>

2011-11-22T10:57:10Z

← Older revision		Revision as of 10:57, 22 November 2011
Line 1:		Line 1:
	__NOTOC__		__NOTOC__
	{{Server function}}		{{Server function}}
	{{New feature\|3.0120\|1.2\|		{{New feature/item\|3.0120\|1.2\|3341\|
	'''Available only in MTA SA 1.1.1 r3341 and onwards'''		'''Available only in MTA SA 1.1.1 r3341 and onwards'''
	}}		}}