The Database API > Database API functions > MMDB.getColumnAndTypeList() |
Availability
Dreamweaver UltraDev 1.0
Description
Gets a list of columns and their types from an executed SQL SELECT statement.
Arguments
connName, statement
connName is the UltraDev connection name as specified in the Connection Manager. It is used to make a database connection to a live data source. |
|
statement is the SQL SELECT statement to execute. |
Returns
An array of strings representing a list of columns (and their types) that match the SELECT statement, or an error if the SQL statement was invalid or the connection could not be made.
Example
The code var columnArray = MMDB.getColumnAndTypeList("EmpDB","Select * from Employees") returns the following array of strings:
columnArray[0] = "EmpName" , columnArray[1] = "varchar", ¬ columnArray[2] = "EmpFirstName", columnArray[3] = "varchar", ¬ columnArray[4] = "Age", columnArray[5] = "integer"