Database access functions

Database access functions let you query a database. For the collection of functions that manage a database connection, see Database connection functions.

The following list describes some of the arguments that are common to the functions that are available:

• Most database access functions use a connection name as an argument. You can see a list of valid connection names in the Connection Manager, or you can use the MMDB.getConnectionList() function to get a list of all the connection names programmatically.
• Stored procedures often require parameters. There are two ways of specifying parameter values for database access functions. First, you can provide an array of parameter values (paramValuesArray). If you specify only parameter values, the values need to be in the sequence in which the stored procedure requires the parameters. Second, you specify parameter values to provide an array of parameter names (paramNameArray). You can use the MMDB.getSPParamsAsString() function to get the parameters of the stored procedure. If you provide parameter names, the values that you specify in paramValuesArray must be in the sequence of the parameter names that you specify in paramNameArray.

Send me an e-mail when comments are added to this page | Comment Report

Current page: http://livedocs.adobe.com/dreamweaver/8/apiref/07_mmd31.htm

Add Comment