![[ Previous ]](navbprev.gif)
![[ Contents ]](navbhome.gif)
![[ Index ]](navbhelp.gif)
![[ Next ]](navbnext.gif)
|
|
|
ns_db exec dbhandle sqlcommand
ns_db gethandle [poolname] nhandles
ns_db open driver datasource user password
ns_db setexception dbhandle code message
ns_db verbose dbhandle ?on | off?
ns_db cancel cancels the current operation.
ns_db close closes the connection. Use this function only on handles that were obtained by the ns_db open function. However, the server automatically close handles when the operation is complete, so you don't normally have to call this function.
ns_db connected returns a boolean value indicating whether the connection to the database pool is made.
ns_db datasource returns the data source for the database pool (e.g., default:mydb).
ns_db dbtype returns the database type of the database pool.
ns_db dml executes SQL that should be data manipulation language such as an insert or update, or data definition language such as a create table.
ns_db driver returns the name of the driver of the handle (e.g., "ILLUSTRA" or "ODBC").
ns_db exception returns the most recent exception for the database pool.
ns_db exec 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). If an error occurs executing the SQL command, an error is thrown. The dbhandle argument is a database handle (obtained with ns_db gethandle). This function can be used for true ad hoc querying, where you don't know what kind of SQL command will be executed.
ns_db flush flushes the results of an SQL select so you do not need to use ns_db getrow to get all the rows and throw them away.
ns_db gethandle returns the specified number of handles from the specified pool. If POOLNAME is not specified, the Defaultpool from the configuration file is used. If NHANDLES is not specified, 1 handle is returned. If not enough handles are available to fulfill the request, it waits until they are available. You must request all the handles you will need for a specific pool with one call to ns_db gethandle. You must release all your database handles explicitly (with ns_db releasehandle) before acquiring more.
ns_db getrow fetches the next row waiting to be retrieved after an ns_db select. The data is dumped right into the set associated with SETID, which should be the set returned by the ns_db select. It returns "1" if there are more rows waiting and returns "0" otherwise. If you call ns_db getrow again after already receiving "0" on the previous call, an error is returned.
ns_db open returns a handle at a lower level, circumventing the pools.
ns_db poolname returns the database pool that this handle came from.
ns_db pools returns a list of all database pools.
ns_db releasehandle puts the handle back in the pool. When your operation has finished running, the server will automatically return any handles to their pools, so you don't normally have to call this function.
ns_db 1row expects the SQL to be a select statement that returns exactly one row and returns that row as an ns_set.
ns_db 0or1row 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.
ns_db password returns the password of the user for the database pool.
ns_db select executes the SQL statement on the database server. It returns an ns_set with the keys set to the column names that were selected. Use ns_db getrow to retrieve rows. You cannot perform nested select statements. Before you start a new select statement, you must first either retrieve all the rows from the first select or use the ns_db flush statement to flush any rows not yet retrieved.
ns_db setexception returns the specified status code and message to the client.
ns_db user returns the user (as specified for the User parameter of the configuration file) for the database pool.
ns_db verbose changes the verbose setting (the Verbose parameter in the configuration file) for the database pool.
|
