Adobe 38040334 API Reference - Page 72

DREAMWEAVER CS3 67 API Reference Returns A comma-delimited string that contains the list of parameters that the stored procedure requires. The parameters' names, direction, and data type are included, separated by semicolons (;). Example The code MMDB.getSPParamsAsString ("EmpDB","getNewEmployeesMakingAtLeast") can return a string of form name startDate;direction:in;datatype:date, salary;direction:in;datatype:integer. In this example, the stored procedure, getNewEmployeesMakingAtLeast, has two parameters: startDate and Salary. For startDate, the direction is in and the data type is date. For salary, the direction is in and the data type is date. MMDB.getTables() Availability Dreamweaver UltraDev 1. Description This function gets a list of all the tables that are defined for the specified database. Each table object has three properties: table, schema, and catalog. Arguments connName • The connName argument is a connection name that is specified in the Connection Manager. It identifies the connection string that Dreamweaver should use to make a database connection to a live data source. Returns An array of objects where each object has three properties: table, schema, and catalog. Table is the name of the table. Schema is the name of the schema that contains the table. Catalog is the catalog that contains the table. Example The statement MMDB.getTables ("EmpDB"); might produce an array of two objects. The first object's properties might be similar to the following example: object1[table:"Employees", schema:"personnel", catalog:"syscat"] The second object's properties might be similar to the following example: object2[table:"Departments", schema:"demo", catalog:"syscat2"] MMDB.getViews() Availability Dreamweaver UltraDev 4. Description This function gets a list of all the views that are defined for the specified database. Each view object has catalog, schema, and view properties. Arguments connName