DbQuery - Revision history

Arran Fortuna: /* Optional Arguments */

2025-08-10T20:38:19Z

Optional Arguments

← Older revision		Revision as of 20:38, 10 August 2025
Line 15:		Line 15:
	===Optional Arguments===		===Optional Arguments===
	*'''callbackFunction:''' An optional function to be called when a result is ready. The function will only be called if the result has not already been read with [[dbPoll]]. The function is called with the query handle as the first argument.		*'''callbackFunction:''' An optional function to be called when a result is ready. The function will only be called if the result has not already been read with [[dbPoll]]. The function is called with the query handle as the first argument.
	*'''callbackArguments:''' An optional table containing extra arguments to be sent to the callback function.		*'''callbackArguments:''' An optional table containing extra arguments (excluding functions) to be sent to the callback function.
	*'''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 '''??''')

Fernando187: Remove obsolete Requirements section

2024-11-07T15:34:48Z

Remove obsolete Requirements section

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

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

	==See Also==		==See Also==
	{{SQL_functions}}		{{SQL_functions}}

Ccw at 03:20, 20 November 2020

2020-11-20T03:20:26Z

← Older revision		Revision as of 03:20, 20 November 2020
Line 14:		Line 14:

	===Optional Arguments===		===Optional Arguments===
	*'''callbackFunction:''' An optional function to be called when a result is ready. The function will only be called if the result has not already been read with [[dbPoll]]. The function is called with the query handle as the first argument. ~~(Notice: Do not use a function with a local prefix)~~		*'''callbackFunction:''' An optional function to be called when a result is ready. The function will only be called if the result has not already been read with [[dbPoll]]. The function is called with the query handle as the first argument.
	*'''callbackArguments:''' An optional table containing extra arguments to be sent to the callback function.		*'''callbackArguments:''' An optional table containing extra arguments to be sent to the callback function.
	*'''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.

Srslyyyy: Added note about async.

2020-08-12T00:47:28Z

Added note about async.

← Older revision		Revision as of 00:47, 12 August 2020
Line 2:		Line 2:
	{{Server function}}		{{Server function}}
	This function starts a database query using the supplied connection. Use the returned query handle with [[dbPoll]] to get the result, or [[dbFree]] if you don't want the result.		This function starts a database query using the supplied connection. Use the returned query handle with [[dbPoll]] to get the result, or [[dbFree]] if you don't want the result.
	{{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''')}}
			{{Important Note\|It is strongly recommended to use this function asynchronously, as presented in "This example starts a select query and processes the result in an inline callback function with custom arguments:"}}
	==Syntax==		==Syntax==
	<syntaxhighlight lang="lua">		<syntaxhighlight lang="lua">

Qaisjp: rename registry functions template

2016-01-04T22:41:26Z

rename registry functions template

← Older revision		Revision as of 22:41, 4 January 2016
Line 70:		Line 70:

	==See Also==		==See Also==
	{{~~Registry_functions~~}}		{{SQL_functions}}

Qaisjp: fix oop syntax

2014-12-28T18:09:56Z

fix oop syntax

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

Strix: OOP

2014-12-27T00:04:02Z

OOP

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

Ccw at 08:48, 7 October 2013

2013-10-07T08:48:01Z

← Older revision		Revision as of 08:48, 7 October 2013
Line 56:		Line 56:
	end		end
	,{"hello",2000}, connection, "SELECT * FROM table_name" )		,{"hello",2000}, connection, "SELECT * FROM table_name" )
			</syntaxhighlight>


			'''''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>

Ccw at 08:44, 7 October 2013

2013-10-07T08:44:35Z

← Older revision		Revision as of 08:44, 7 October 2013
Line 54:		Line 54:
	outputDebugString( tag ) -- Prints "hello"		outputDebugString( tag ) -- Prints "hello"
	outputDebugString( score ) -- Prints 2000		outputDebugString( score ) -- Prints 2000
	end, {"hello",2000}, connection, "SELECT * FROM table_name" )		end
			,{"hello",2000}, connection, "SELECT * FROM table_name" )
	</syntaxhighlight>		</syntaxhighlight>

Ccw at 05:46, 1 September 2012

2012-09-01T05:46:24Z

← Older revision		Revision as of 05:46, 1 September 2012
Line 2:		Line 2:
	{{Server function}}		{{Server function}}
	This function starts a database query using the supplied connection. Use the returned query handle with [[dbPoll]] to get the result, or [[dbFree]] if you don't want the result.		This function starts a database query using the supplied connection. Use the returned query handle with [[dbPoll]] to get the result, or [[dbFree]] if you don't want the result.
			{{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">