Adobe 38040334 API Reference - Page 51

Chapter 7: The database API Functions in the database API let you manage database connections and access information that is stored in databases. The database API is divided by two distinct purposes: managing and accessing database connections. In managing database connections, you can get the user name and password needed to make a connection to a database, open up a database connection dialog box, and so on. In accessing database information, you can, for example, retrieve metadata that describes the schema or structure of a database. This metadata includes information such as the names of tables, columns, stored procedures, and views. You can also show the results of executing a database query or stored procedure. When accessing a database through this API, you use structured query language (SQL) statements. Database API functions are used at design time when users are building web applications, not at runtime when the web application is deployed. You can use these functions in any extension. In fact, the Adobe® Dreamweaver® CS3 server behavior, data format, and data sources APIs all use these database functions. The functions described in this chapter are grouped into the following sections: • "Database connection functions" on page 47 • "Database access functions" on page 59 How database API functions work The following example shows how the server behavior function, getDynamicBindings(), is defined for Recordset.js. This example uses the MMDB.getColumnAndTypeList() function: