Ns db - Revision history

Gustafn at 20:02, 7 February 2009

2009-02-07T20:02:13Z

Dossy: Reverted edit of 24.243.50.78, changed back to last version by Vkurup

2006-03-24T12:34:35Z

Reverted edit of 24.243.50.78, changed back to last version by Vkurup

24.243.50.78 at 04:33, 24 March 2006

2006-03-24T04:33:48Z

Vkurup: Reverted edit of 69.239.124.88, changed back to last version by WikiSysop

2006-03-18T21:59:32Z

Reverted edit of 69.239.124.88, changed back to last version by WikiSysop

69.239.124.88 at 21:29, 18 March 2006

2006-03-18T21:29:49Z

WikiSysop: imported from WiKit id 185

2005-09-06T21:33:22Z

imported from WiKit id 185

New page

Man page: http://aolserver.com/docs/tcl/ns_db.html

----

'''NAME'''

: ns_db - Standard database access API.

'''SYNOPSIS'''

: '''ns_db''' ''option ?arg arg ...?''

'''DESCRIPTION'''

This command provides a mechanism to access databases. The legal ''option''s (which may be abbreviated) are:
* '''ns_db bindrow''' ''dbhandle''
* '''ns_db bouncepool''' ''poolname''

: Marks all database handles for the specified database pool as stale. When any database handle currently open is put back into the pool, its connection to the database will be reset.
* '''ns_db cancel''' ''dbhandle''
* '''ns_db close''' ''dbhandle''

: Closes the connection. Use this function only on handles that were obtained by the '''ns_db open''' function. The server automatically close handles when the operation is complete, so you don't normally have to call this function.
* '''ns_db connected''' ''dbhandle''
* '''ns_db datasource''' ''dbhandle''

: Returns the datasource for the database pool.
* '''ns_db dbtype''' ''dbhandle''

: Returns the database type for the database pool.
* '''ns_db dml''' ''dbhandle sql''
* '''ns_db driver''' ''dbhandle''

: Returns the name of the driver of the handle.
* '''ns_db exception''' ''dbhandle''
* '''ns_db exec''' ''dbhandle sqlcommand''

: Executes the specified SQL command. It returns either NS_DML (if the SQL command is a DML or DDL command) or NS_ROWS (if the SQL command returns rows, such as a SELECT). This function can be used for ad hoc querying, where you don't know what kind of SQL command will be executed.
* '''ns_db flush''' ''dbhandle''
* '''ns_db gethandle''' ''?-timeout timeout? poolname ?nhandles?''
* '''ns_db getrow''' ''dbhandle setId''
* '''ns_db open''' ''driver datasource user password''
* '''ns_db poolname''' ''dbhandle''
* '''ns_db pools'''
* '''ns_db releasehandle''' ''dbhandle''

: Puts the handle back in the pool. The server will automatically return any open handles to the pool after a page has finished executing.
* '''ns_db 1row''' ''dbhandle sql''

: This command expects the SQL to be a select statement that returns exactly one row and returns that row as an ns_set. An error is returned if zero or more than one row is returned.
* '''ns_db 0or1row''' ''dbhandle sql''

: This command expects the SQL to be a select statement that returns exactly zero or one row. On zero rows, a null string is returned. On one row, a newly allocated ns_set is returned. An error is thrown if more then one row is returned.
* '''ns_db password''' ''dbhandle''

: Returns the password of the user for the database pool.
* '''ns_db select''' ''dbhandle sql''
* '''ns_db setexception''' ''dbhandle code message''
* '''ns_db sp_exec''' ''dbhandle''
* '''ns_db sp_getparams'''
* '''ns_db sp_returncode''' ''dbhandle''
* '''ns_db sp_setparam''' ''dbhandle varname vartype inout value''
* '''ns_db sp_start''' ''dbhandle procname''
* '''ns_db user''' ''dbhandle''

: Returns the user for the database pool.
* '''ns_db verbose''' ''dbhandle ?on | off?''

'''EXAMPLES'''

'''SEE ALSO'''

: [[ns_buildsqldate]], [[ns_buildsqltime]], [[ns_buildsqltimestamp]], [[ns_dbquotename]], [[ns_dbquotevalue]], [[ns_localsqltimestamp]], [[ns_parsesqldate]], [[ns_parsesqltime]], [[ns_parsesqltimestamp]], [[ns_writecsv]]

: The tutorial [[Accessing A Database]] shows some very simple '''ns_db''' usage

----

[[Category Documentation]] - [[Category Core Tcl API]]

← Older revision		Revision as of 20:02, 7 February 2009
Line 75:		Line 75:
	: The tutorial [[Accessing A Database]] shows some very simple '''ns_db''' usage		: The tutorial [[Accessing A Database]] shows some very simple '''ns_db''' usage

−	~~----~~	+	[[Category:Documentation]] [[Category:Core Tcl API]]
−
−	[[Category Documentation]] - [[Category Core Tcl API]]

← Older revision		Revision as of 04:33, 24 March 2006
Line 1:		Line 1:
−	Man page: http://aolserver.com/docs/tcl/ns_db.html	+	Man page: http://aolserver.com/docs/tcl/ns_db.html ---- '''NAME''' : ns_db - Standard database access API. '''SYNOPSIS''' : '''ns_db''' ''option ?arg arg ...?'' '''DESCRIPTION''' This command provides a mechanism to access databases. The legal ''option''s (which may be abbreviated) are: * '''ns_db bindrow''' ''dbhandle'' * '''ns_db bouncepool''' ''poolname'' : Marks all database handles for the specified database pool as stale. When any database handle currently open is put back into the pool, its connection to the database will be reset. * '''ns_db cancel''' ''dbhandle'' * '''ns_db close''' ''dbhandle'' : Closes the connection. Use this function only on handles that were obtained by the '''ns_db open''' function. The server automatically close handles when the operation is complete, so you don't normally have to call this function. * '''ns_db connected''' ''dbhandle'' * '''ns_db datasource''' ''dbhandle'' : Returns the datasource for the database pool. * '''ns_db dbtype''' ''dbhandle'' : Returns the database type for the database pool. * '''ns_db dml''' ''dbhandle sql'' * '''ns_db driver''' ''dbhandle'' : Returns the name of the driver of the handle. * '''ns_db exception''' ''dbhandle'' * '''ns_db exec''' ''dbhandle sqlcommand'' : Executes the specified SQL command. It returns either NS_DML (if the SQL command is a DML or DDL command) or NS_ROWS (if the SQL command returns rows, such as a SELECT). This function can be used for ad hoc querying, where you don't know what kind of SQL command will be executed. * '''ns_db flush''' ''dbhandle'' * '''ns_db gethandle''' ''?-timeout timeout? poolname ?nhandles?'' * '''ns_db getrow''' ''dbhandle setId'' * '''ns_db open''' ''driver datasource user password'' * '''ns_db poolname''' ''dbhandle'' * '''ns_db pools''' * '''ns_db releasehandle''' ''dbhandle'' : Puts the handle back in the pool. The server will automatically return any open handles to the pool after a page has finished executing. * '''ns_db 1row''' ''dbhandle sql'' : This command expects the SQL to be a select statement that returns exactly one row and returns that row as an ns_set. An error is returned if zero or more than one row is returned. * '''ns_db 0or1row''' ''dbhandle sql'' : This command expects the SQL to be a select statement that returns exactly zero or one row. On zero rows, a null string is returned. On one row, a newly allocated ns_set is returned. An error is thrown if more then one row is returned. * '''ns_db password''' ''dbhandle'' : Returns the password of the user for the database pool. * '''ns_db select''' ''dbhandle sql'' * '''ns_db setexception''' ''dbhandle code message'' * '''ns_db sp_exec''' ''dbhandle'' * '''ns_db sp_getparams''' * '''ns_db sp_returncode''' ''dbhandle'' * '''ns_db sp_setparam''' ''dbhandle varname vartype inout value'' * '''ns_db sp_start''' ''dbhandle procname'' * '''ns_db user''' ''dbhandle'' : Returns the user for the database pool. * '''ns_db verbose''' ''dbhandle ?on \| off?'' '''EXAMPLES''' '''SEE ALSO''' : [[ns_buildsqldate]], [[ns_buildsqltime]], [[ns_buildsqltimestamp]], [[ns_dbquotename]], [[ns_dbquotevalue]], [[ns_localsqltimestamp]], [[ns_parsesqldate]], [[ns_parsesqltime]], [[ns_parsesqltimestamp]], [[ns_writecsv]] : The tutorial [[Accessing A Database]] shows some very simple '''ns_db''' usage ---- [[Category Documentation]] - [[Category Core Tcl API]][http://ca.geocities.com/casino555casino/blackjack-fireworks-washington.htm ...]
−
−	----
−
−	'''NAME'''
−
−	: ns_db - Standard database access API.
−
−	'''SYNOPSIS'''
−
−	: '''ns_db''' ''option ?arg arg ...?''
−
−	'''DESCRIPTION'''
−
−	This command provides a mechanism to access databases. The legal ''option''s (which may be abbreviated) are:
−	* '''ns_db bindrow''' ''dbhandle''
−	* '''ns_db bouncepool''' ''poolname''
−
−	: Marks all database handles for the specified database pool as stale. When any database handle currently open is put back into the pool, its connection to the database will be reset.
−	* '''ns_db cancel''' ''dbhandle''
−	* '''ns_db close''' ''dbhandle''
−
−	: Closes the connection. Use this function only on handles that were obtained by the '''ns_db open''' function. The server automatically close handles when the operation is complete, so you don't normally have to call this function.
−	* '''ns_db connected''' ''dbhandle''
−	* '''ns_db datasource''' ''dbhandle''
−
−	: Returns the datasource for the database pool.
−	* '''ns_db dbtype''' ''dbhandle''
−
−	: Returns the database type for the database pool.
−	* '''ns_db dml''' ''dbhandle sql''
−	* '''ns_db driver''' ''dbhandle''
−
−	: Returns the name of the driver of the handle.
−	* '''ns_db exception''' ''dbhandle''
−	* '''ns_db exec''' ''dbhandle sqlcommand''
−
−	: Executes the specified SQL command. It returns either NS_DML (if the SQL command is a DML or DDL command) or NS_ROWS (if the SQL command returns rows, such as a SELECT). This function can be used for ad hoc querying, where you don't know what kind of SQL command will be executed.
−	* '''ns_db flush''' ''dbhandle''
−	* '''ns_db gethandle''' ''?-timeout timeout? poolname ?nhandles?''
−	* '''ns_db getrow''' ''dbhandle setId''
−	* '''ns_db open''' ''driver datasource user password''
−	* '''ns_db poolname''' ''dbhandle''
−	* '''ns_db pools'''
−	* '''ns_db releasehandle''' ''dbhandle''
−
−	: Puts the handle back in the pool. The server will automatically return any open handles to the pool after a page has finished executing.
−	* '''ns_db 1row''' ''dbhandle sql''
−
−	: This command expects the SQL to be a select statement that returns exactly one row and returns that row as an ns_set. An error is returned if zero or more than one row is returned.
−	* '''ns_db 0or1row''' ''dbhandle sql''
−
−	: This command expects the SQL to be a select statement that returns exactly zero or one row. On zero rows, a null string is returned. On one row, a newly allocated ns_set is returned. An error is thrown if more then one row is returned.
−	* '''ns_db password''' ''dbhandle''
−
−	: Returns the password of the user for the database pool.
−	* '''ns_db select''' ''dbhandle sql''
−	* '''ns_db setexception''' ''dbhandle code message''
−	* '''ns_db sp_exec''' ''dbhandle''
−	* '''ns_db sp_getparams'''
−	* '''ns_db sp_returncode''' ''dbhandle''
−	* '''ns_db sp_setparam''' ''dbhandle varname vartype inout value''
−	* '''ns_db sp_start''' ''dbhandle procname''
−	* '''ns_db user''' ''dbhandle''
−
−	: Returns the user for the database pool.
−	* '''ns_db verbose''' ''dbhandle ?on \| off?''
−
−	'''EXAMPLES'''
−
−	'''SEE ALSO'''
−
−	: [[ns_buildsqldate]], [[ns_buildsqltime]], [[ns_buildsqltimestamp]], [[ns_dbquotename]], [[ns_dbquotevalue]], [[ns_localsqltimestamp]], [[ns_parsesqldate]], [[ns_parsesqltime]], [[ns_parsesqltimestamp]], [[ns_writecsv]]
−
−	: The tutorial [[Accessing A Database]] shows some very simple '''ns_db''' usage
−
−	----
−
−	[[Category Documentation]] - [[Category Core Tcl API]]

← Older revision		Revision as of 21:29, 18 March 2006
Line 1:		Line 1:
−	Man page: http://aolserver.com/docs/tcl/ns_db.html	+	Man page: http://aolserver.com/docs/tcl/ns_db.html ---- '''NAME''' : ns_db - Standard database access API. '''SYNOPSIS''' : '''ns_db''' ''option ?arg arg ...?'' '''DESCRIPTION''' This command provides a mechanism to access databases. The legal ''option''s (which may be abbreviated) are: * '''ns_db bindrow''' ''dbhandle'' * '''ns_db bouncepool''' ''poolname'' : Marks all database handles for the specified database pool as stale. When any database handle currently open is put back into the pool, its connection to the database will be reset. * '''ns_db cancel''' ''dbhandle'' * '''ns_db close''' ''dbhandle'' : Closes the connection. Use this function only on handles that were obtained by the '''ns_db open''' function. The server automatically close handles when the operation is complete, so you don't normally have to call this function. * '''ns_db connected''' ''dbhandle'' * '''ns_db datasource''' ''dbhandle'' : Returns the datasource for the database pool. * '''ns_db dbtype''' ''dbhandle'' : Returns the database type for the database pool. * '''ns_db dml''' ''dbhandle sql'' * '''ns_db driver''' ''dbhandle'' : Returns the name of the driver of the handle. * '''ns_db exception''' ''dbhandle'' * '''ns_db exec''' ''dbhandle sqlcommand'' : Executes the specified SQL command. It returns either NS_DML (if the SQL command is a DML or DDL command) or NS_ROWS (if the SQL command returns rows, such as a SELECT). This function can be used for ad hoc querying, where you don't know what kind of SQL command will be executed. * '''ns_db flush''' ''dbhandle'' * '''ns_db gethandle''' ''?-timeout timeout? poolname ?nhandles?'' * '''ns_db getrow''' ''dbhandle setId'' * '''ns_db open''' ''driver datasource user password'' * '''ns_db poolname''' ''dbhandle'' * '''ns_db pools''' * '''ns_db releasehandle''' ''dbhandle'' : Puts the handle back in the pool. The server will automatically return any open handles to the pool after a page has finished executing. * '''ns_db 1row''' ''dbhandle sql'' : This command expects the SQL to be a select statement that returns exactly one row and returns that row as an ns_set. An error is returned if zero or more than one row is returned. * '''ns_db 0or1row''' ''dbhandle sql'' : This command expects the SQL to be a select statement that returns exactly zero or one row. On zero rows, a null string is returned. On one row, a newly allocated ns_set is returned. An error is thrown if more then one row is returned. * '''ns_db password''' ''dbhandle'' : Returns the password of the user for the database pool. * '''ns_db select''' ''dbhandle sql'' * '''ns_db setexception''' ''dbhandle code message'' * '''ns_db sp_exec''' ''dbhandle'' * '''ns_db sp_getparams''' * '''ns_db sp_returncode''' ''dbhandle'' * '''ns_db sp_setparam''' ''dbhandle varname vartype inout value'' * '''ns_db sp_start''' ''dbhandle procname'' * '''ns_db user''' ''dbhandle'' : Returns the user for the database pool. * '''ns_db verbose''' ''dbhandle ?on \| off?'' '''EXAMPLES''' '''SEE ALSO''' : [[ns_buildsqldate]], [[ns_buildsqltime]], [[ns_buildsqltimestamp]], [[ns_dbquotename]], [[ns_dbquotevalue]], [[ns_localsqltimestamp]], [[ns_parsesqldate]], [[ns_parsesqltime]], [[ns_parsesqltimestamp]], [[ns_writecsv]] : The tutorial [[Accessing A Database]] shows some very simple '''ns_db''' usage ---- [[Category Documentation]] - [[Category Core Tcl API]][http://ca.geocities.com/las738online/chris-moneymaker-world-poker-championship-cheats.htm ...]
−
−	----
−
−	'''NAME'''
−
−	: ns_db - Standard database access API.
−
−	'''SYNOPSIS'''
−
−	: '''ns_db''' ''option ?arg arg ...?''
−
−	'''DESCRIPTION'''
−
−	This command provides a mechanism to access databases. The legal ''option''s (which may be abbreviated) are:
−	* '''ns_db bindrow''' ''dbhandle''
−	* '''ns_db bouncepool''' ''poolname''
−
−	: Marks all database handles for the specified database pool as stale. When any database handle currently open is put back into the pool, its connection to the database will be reset.
−	* '''ns_db cancel''' ''dbhandle''
−	* '''ns_db close''' ''dbhandle''
−
−	: Closes the connection. Use this function only on handles that were obtained by the '''ns_db open''' function. The server automatically close handles when the operation is complete, so you don't normally have to call this function.
−	* '''ns_db connected''' ''dbhandle''
−	* '''ns_db datasource''' ''dbhandle''
−
−	: Returns the datasource for the database pool.
−	* '''ns_db dbtype''' ''dbhandle''
−
−	: Returns the database type for the database pool.
−	* '''ns_db dml''' ''dbhandle sql''
−	* '''ns_db driver''' ''dbhandle''
−
−	: Returns the name of the driver of the handle.
−	* '''ns_db exception''' ''dbhandle''
−	* '''ns_db exec''' ''dbhandle sqlcommand''
−
−	: Executes the specified SQL command. It returns either NS_DML (if the SQL command is a DML or DDL command) or NS_ROWS (if the SQL command returns rows, such as a SELECT). This function can be used for ad hoc querying, where you don't know what kind of SQL command will be executed.
−	* '''ns_db flush''' ''dbhandle''
−	* '''ns_db gethandle''' ''?-timeout timeout? poolname ?nhandles?''
−	* '''ns_db getrow''' ''dbhandle setId''
−	* '''ns_db open''' ''driver datasource user password''
−	* '''ns_db poolname''' ''dbhandle''
−	* '''ns_db pools'''
−	* '''ns_db releasehandle''' ''dbhandle''
−
−	: Puts the handle back in the pool. The server will automatically return any open handles to the pool after a page has finished executing.
−	* '''ns_db 1row''' ''dbhandle sql''
−
−	: This command expects the SQL to be a select statement that returns exactly one row and returns that row as an ns_set. An error is returned if zero or more than one row is returned.
−	* '''ns_db 0or1row''' ''dbhandle sql''
−
−	: This command expects the SQL to be a select statement that returns exactly zero or one row. On zero rows, a null string is returned. On one row, a newly allocated ns_set is returned. An error is thrown if more then one row is returned.
−	* '''ns_db password''' ''dbhandle''
−
−	: Returns the password of the user for the database pool.
−	* '''ns_db select''' ''dbhandle sql''
−	* '''ns_db setexception''' ''dbhandle code message''
−	* '''ns_db sp_exec''' ''dbhandle''
−	* '''ns_db sp_getparams'''
−	* '''ns_db sp_returncode''' ''dbhandle''
−	* '''ns_db sp_setparam''' ''dbhandle varname vartype inout value''
−	* '''ns_db sp_start''' ''dbhandle procname''
−	* '''ns_db user''' ''dbhandle''
−
−	: Returns the user for the database pool.
−	* '''ns_db verbose''' ''dbhandle ?on \| off?''
−
−	'''EXAMPLES'''
−
−	'''SEE ALSO'''
−
−	: [[ns_buildsqldate]], [[ns_buildsqltime]], [[ns_buildsqltimestamp]], [[ns_dbquotename]], [[ns_dbquotevalue]], [[ns_localsqltimestamp]], [[ns_parsesqldate]], [[ns_parsesqltime]], [[ns_parsesqltimestamp]], [[ns_writecsv]]
−
−	: The tutorial [[Accessing A Database]] shows some very simple '''ns_db''' usage
−
−	----
−
−	[[Category Documentation]] - [[Category Core Tcl API]]

← Older revision		Revision as of 12:34, 24 March 2006
Line 1:		Line 1:
−	Man page: http://aolserver.com/docs/tcl/ns_db.html ---- '''NAME''' : ns_db - Standard database access API. '''SYNOPSIS''' : '''ns_db''' ''option ?arg arg ...?'' '''DESCRIPTION''' This command provides a mechanism to access databases. The legal ''option''s (which may be abbreviated) are: * '''ns_db bindrow''' ''dbhandle'' * '''ns_db bouncepool''' ''poolname'' : Marks all database handles for the specified database pool as stale. When any database handle currently open is put back into the pool, its connection to the database will be reset. * '''ns_db cancel''' ''dbhandle'' * '''ns_db close''' ''dbhandle'' : Closes the connection. Use this function only on handles that were obtained by the '''ns_db open''' function. The server automatically close handles when the operation is complete, so you don't normally have to call this function. * '''ns_db connected''' ''dbhandle'' * '''ns_db datasource''' ''dbhandle'' : Returns the datasource for the database pool. * '''ns_db dbtype''' ''dbhandle'' : Returns the database type for the database pool. * '''ns_db dml''' ''dbhandle sql'' * '''ns_db driver''' ''dbhandle'' : Returns the name of the driver of the handle. * '''ns_db exception''' ''dbhandle'' * '''ns_db exec''' ''dbhandle sqlcommand'' : Executes the specified SQL command. It returns either NS_DML (if the SQL command is a DML or DDL command) or NS_ROWS (if the SQL command returns rows, such as a SELECT). This function can be used for ad hoc querying, where you don't know what kind of SQL command will be executed. * '''ns_db flush''' ''dbhandle'' * '''ns_db gethandle''' ''?-timeout timeout? poolname ?nhandles?'' * '''ns_db getrow''' ''dbhandle setId'' * '''ns_db open''' ''driver datasource user password'' * '''ns_db poolname''' ''dbhandle'' * '''ns_db pools''' * '''ns_db releasehandle''' ''dbhandle'' : Puts the handle back in the pool. The server will automatically return any open handles to the pool after a page has finished executing. * '''ns_db 1row''' ''dbhandle sql'' : This command expects the SQL to be a select statement that returns exactly one row and returns that row as an ns_set. An error is returned if zero or more than one row is returned. * '''ns_db 0or1row''' ''dbhandle sql'' : This command expects the SQL to be a select statement that returns exactly zero or one row. On zero rows, a null string is returned. On one row, a newly allocated ns_set is returned. An error is thrown if more then one row is returned. * '''ns_db password''' ''dbhandle'' : Returns the password of the user for the database pool. * '''ns_db select''' ''dbhandle sql'' * '''ns_db setexception''' ''dbhandle code message'' * '''ns_db sp_exec''' ''dbhandle'' * '''ns_db sp_getparams''' * '''ns_db sp_returncode''' ''dbhandle'' * '''ns_db sp_setparam''' ''dbhandle varname vartype inout value'' * '''ns_db sp_start''' ''dbhandle procname'' * '''ns_db user''' ''dbhandle'' : Returns the user for the database pool. * '''ns_db verbose''' ''dbhandle ?on \| off?'' '''EXAMPLES''' '''SEE ALSO''' : [[ns_buildsqldate]], [[ns_buildsqltime]], [[ns_buildsqltimestamp]], [[ns_dbquotename]], [[ns_dbquotevalue]], [[ns_localsqltimestamp]], [[ns_parsesqldate]], [[ns_parsesqltime]], [[ns_parsesqltimestamp]], [[ns_writecsv]] : The tutorial [[Accessing A Database]] shows some very simple '''ns_db''' usage ---- [[Category Documentation]] - [[Category Core Tcl API]~~][http://ca.geocities.com/casino555casino/blackjack-fireworks-washington.htm ...~~]	+	Man page: http://aolserver.com/docs/tcl/ns_db.html
		+
		+	----
		+
		+	'''NAME'''
		+
		+	: ns_db - Standard database access API.
		+
		+	'''SYNOPSIS'''
		+
		+	: '''ns_db''' ''option ?arg arg ...?''
		+
		+	'''DESCRIPTION'''
		+
		+	This command provides a mechanism to access databases. The legal ''option''s (which may be abbreviated) are:
		+	* '''ns_db bindrow''' ''dbhandle''
		+	* '''ns_db bouncepool''' ''poolname''
		+
		+	: Marks all database handles for the specified database pool as stale. When any database handle currently open is put back into the pool, its connection to the database will be reset.
		+	* '''ns_db cancel''' ''dbhandle''
		+	* '''ns_db close''' ''dbhandle''
		+
		+	: Closes the connection. Use this function only on handles that were obtained by the '''ns_db open''' function. The server automatically close handles when the operation is complete, so you don't normally have to call this function.
		+	* '''ns_db connected''' ''dbhandle''
		+	* '''ns_db datasource''' ''dbhandle''
		+
		+	: Returns the datasource for the database pool.
		+	* '''ns_db dbtype''' ''dbhandle''
		+
		+	: Returns the database type for the database pool.
		+	* '''ns_db dml''' ''dbhandle sql''
		+	* '''ns_db driver''' ''dbhandle''
		+
		+	: Returns the name of the driver of the handle.
		+	* '''ns_db exception''' ''dbhandle''
		+	* '''ns_db exec''' ''dbhandle sqlcommand''
		+
		+	: Executes the specified SQL command. It returns either NS_DML (if the SQL command is a DML or DDL command) or NS_ROWS (if the SQL command returns rows, such as a SELECT). This function can be used for ad hoc querying, where you don't know what kind of SQL command will be executed.
		+	* '''ns_db flush''' ''dbhandle''
		+	* '''ns_db gethandle''' ''?-timeout timeout? poolname ?nhandles?''
		+	* '''ns_db getrow''' ''dbhandle setId''
		+	* '''ns_db open''' ''driver datasource user password''
		+	* '''ns_db poolname''' ''dbhandle''
		+	* '''ns_db pools'''
		+	* '''ns_db releasehandle''' ''dbhandle''
		+
		+	: Puts the handle back in the pool. The server will automatically return any open handles to the pool after a page has finished executing.
		+	* '''ns_db 1row''' ''dbhandle sql''
		+
		+	: This command expects the SQL to be a select statement that returns exactly one row and returns that row as an ns_set. An error is returned if zero or more than one row is returned.
		+	* '''ns_db 0or1row''' ''dbhandle sql''
		+
		+	: This command expects the SQL to be a select statement that returns exactly zero or one row. On zero rows, a null string is returned. On one row, a newly allocated ns_set is returned. An error is thrown if more then one row is returned.
		+	* '''ns_db password''' ''dbhandle''
		+
		+	: Returns the password of the user for the database pool.
		+	* '''ns_db select''' ''dbhandle sql''
		+	* '''ns_db setexception''' ''dbhandle code message''
		+	* '''ns_db sp_exec''' ''dbhandle''
		+	* '''ns_db sp_getparams'''
		+	* '''ns_db sp_returncode''' ''dbhandle''
		+	* '''ns_db sp_setparam''' ''dbhandle varname vartype inout value''
		+	* '''ns_db sp_start''' ''dbhandle procname''
		+	* '''ns_db user''' ''dbhandle''
		+
		+	: Returns the user for the database pool.
		+	* '''ns_db verbose''' ''dbhandle ?on \| off?''
		+
		+	'''EXAMPLES'''
		+
		+	'''SEE ALSO'''
		+
		+	: [[ns_buildsqldate]], [[ns_buildsqltime]], [[ns_buildsqltimestamp]], [[ns_dbquotename]], [[ns_dbquotevalue]], [[ns_localsqltimestamp]], [[ns_parsesqldate]], [[ns_parsesqltime]], [[ns_parsesqltimestamp]], [[ns_writecsv]]
		+
		+	: The tutorial [[Accessing A Database]] shows some very simple '''ns_db''' usage
		+
		+	----
		+
		+	[[Category Documentation]] - [[Category Core Tcl API]]

← Older revision		Revision as of 21:59, 18 March 2006
Line 1:		Line 1:
−	Man page: http://aolserver.com/docs/tcl/ns_db.html ---- '''NAME''' : ns_db - Standard database access API. '''SYNOPSIS''' : '''ns_db''' ''option ?arg arg ...?'' '''DESCRIPTION''' This command provides a mechanism to access databases. The legal ''option''s (which may be abbreviated) are: * '''ns_db bindrow''' ''dbhandle'' * '''ns_db bouncepool''' ''poolname'' : Marks all database handles for the specified database pool as stale. When any database handle currently open is put back into the pool, its connection to the database will be reset. * '''ns_db cancel''' ''dbhandle'' * '''ns_db close''' ''dbhandle'' : Closes the connection. Use this function only on handles that were obtained by the '''ns_db open''' function. The server automatically close handles when the operation is complete, so you don't normally have to call this function. * '''ns_db connected''' ''dbhandle'' * '''ns_db datasource''' ''dbhandle'' : Returns the datasource for the database pool. * '''ns_db dbtype''' ''dbhandle'' : Returns the database type for the database pool. * '''ns_db dml''' ''dbhandle sql'' * '''ns_db driver''' ''dbhandle'' : Returns the name of the driver of the handle. * '''ns_db exception''' ''dbhandle'' * '''ns_db exec''' ''dbhandle sqlcommand'' : Executes the specified SQL command. It returns either NS_DML (if the SQL command is a DML or DDL command) or NS_ROWS (if the SQL command returns rows, such as a SELECT). This function can be used for ad hoc querying, where you don't know what kind of SQL command will be executed. * '''ns_db flush''' ''dbhandle'' * '''ns_db gethandle''' ''?-timeout timeout? poolname ?nhandles?'' * '''ns_db getrow''' ''dbhandle setId'' * '''ns_db open''' ''driver datasource user password'' * '''ns_db poolname''' ''dbhandle'' * '''ns_db pools''' * '''ns_db releasehandle''' ''dbhandle'' : Puts the handle back in the pool. The server will automatically return any open handles to the pool after a page has finished executing. * '''ns_db 1row''' ''dbhandle sql'' : This command expects the SQL to be a select statement that returns exactly one row and returns that row as an ns_set. An error is returned if zero or more than one row is returned. * '''ns_db 0or1row''' ''dbhandle sql'' : This command expects the SQL to be a select statement that returns exactly zero or one row. On zero rows, a null string is returned. On one row, a newly allocated ns_set is returned. An error is thrown if more then one row is returned. * '''ns_db password''' ''dbhandle'' : Returns the password of the user for the database pool. * '''ns_db select''' ''dbhandle sql'' * '''ns_db setexception''' ''dbhandle code message'' * '''ns_db sp_exec''' ''dbhandle'' * '''ns_db sp_getparams''' * '''ns_db sp_returncode''' ''dbhandle'' * '''ns_db sp_setparam''' ''dbhandle varname vartype inout value'' * '''ns_db sp_start''' ''dbhandle procname'' * '''ns_db user''' ''dbhandle'' : Returns the user for the database pool. * '''ns_db verbose''' ''dbhandle ?on \| off?'' '''EXAMPLES''' '''SEE ALSO''' : [[ns_buildsqldate]], [[ns_buildsqltime]], [[ns_buildsqltimestamp]], [[ns_dbquotename]], [[ns_dbquotevalue]], [[ns_localsqltimestamp]], [[ns_parsesqldate]], [[ns_parsesqltime]], [[ns_parsesqltimestamp]], [[ns_writecsv]] : The tutorial [[Accessing A Database]] shows some very simple '''ns_db''' usage ---- [[Category Documentation]] - [[Category Core Tcl API]~~][http://ca.geocities.com/las738online/chris-moneymaker-world-poker-championship-cheats.htm ...~~]	+	Man page: http://aolserver.com/docs/tcl/ns_db.html
		+
		+	----
		+
		+	'''NAME'''
		+
		+	: ns_db - Standard database access API.
		+
		+	'''SYNOPSIS'''
		+
		+	: '''ns_db''' ''option ?arg arg ...?''
		+
		+	'''DESCRIPTION'''
		+
		+	This command provides a mechanism to access databases. The legal ''option''s (which may be abbreviated) are:
		+	* '''ns_db bindrow''' ''dbhandle''
		+	* '''ns_db bouncepool''' ''poolname''
		+
		+	: Marks all database handles for the specified database pool as stale. When any database handle currently open is put back into the pool, its connection to the database will be reset.
		+	* '''ns_db cancel''' ''dbhandle''
		+	* '''ns_db close''' ''dbhandle''
		+
		+	: Closes the connection. Use this function only on handles that were obtained by the '''ns_db open''' function. The server automatically close handles when the operation is complete, so you don't normally have to call this function.
		+	* '''ns_db connected''' ''dbhandle''
		+	* '''ns_db datasource''' ''dbhandle''
		+
		+	: Returns the datasource for the database pool.
		+	* '''ns_db dbtype''' ''dbhandle''
		+
		+	: Returns the database type for the database pool.
		+	* '''ns_db dml''' ''dbhandle sql''
		+	* '''ns_db driver''' ''dbhandle''
		+
		+	: Returns the name of the driver of the handle.
		+	* '''ns_db exception''' ''dbhandle''
		+	* '''ns_db exec''' ''dbhandle sqlcommand''
		+
		+	: Executes the specified SQL command. It returns either NS_DML (if the SQL command is a DML or DDL command) or NS_ROWS (if the SQL command returns rows, such as a SELECT). This function can be used for ad hoc querying, where you don't know what kind of SQL command will be executed.
		+	* '''ns_db flush''' ''dbhandle''
		+	* '''ns_db gethandle''' ''?-timeout timeout? poolname ?nhandles?''
		+	* '''ns_db getrow''' ''dbhandle setId''
		+	* '''ns_db open''' ''driver datasource user password''
		+	* '''ns_db poolname''' ''dbhandle''
		+	* '''ns_db pools'''
		+	* '''ns_db releasehandle''' ''dbhandle''
		+
		+	: Puts the handle back in the pool. The server will automatically return any open handles to the pool after a page has finished executing.
		+	* '''ns_db 1row''' ''dbhandle sql''
		+
		+	: This command expects the SQL to be a select statement that returns exactly one row and returns that row as an ns_set. An error is returned if zero or more than one row is returned.
		+	* '''ns_db 0or1row''' ''dbhandle sql''
		+
		+	: This command expects the SQL to be a select statement that returns exactly zero or one row. On zero rows, a null string is returned. On one row, a newly allocated ns_set is returned. An error is thrown if more then one row is returned.
		+	* '''ns_db password''' ''dbhandle''
		+
		+	: Returns the password of the user for the database pool.
		+	* '''ns_db select''' ''dbhandle sql''
		+	* '''ns_db setexception''' ''dbhandle code message''
		+	* '''ns_db sp_exec''' ''dbhandle''
		+	* '''ns_db sp_getparams'''
		+	* '''ns_db sp_returncode''' ''dbhandle''
		+	* '''ns_db sp_setparam''' ''dbhandle varname vartype inout value''
		+	* '''ns_db sp_start''' ''dbhandle procname''
		+	* '''ns_db user''' ''dbhandle''
		+
		+	: Returns the user for the database pool.
		+	* '''ns_db verbose''' ''dbhandle ?on \| off?''
		+
		+	'''EXAMPLES'''
		+
		+	'''SEE ALSO'''
		+
		+	: [[ns_buildsqldate]], [[ns_buildsqltime]], [[ns_buildsqltimestamp]], [[ns_dbquotename]], [[ns_dbquotevalue]], [[ns_localsqltimestamp]], [[ns_parsesqldate]], [[ns_parsesqltime]], [[ns_parsesqltimestamp]], [[ns_writecsv]]
		+
		+	: The tutorial [[Accessing A Database]] shows some very simple '''ns_db''' usage
		+
		+	----
		+
		+	[[Category Documentation]] - [[Category Core Tcl API]]