Table of Contents
DB_Sql is used by CT_Sql and Auth to access a SQL database. You are encouraged to use it directly, too.
Accessible instance variables
| Host | Host where your SQL server is running on. |
| Database | Name of database or instance to use on that server. |
| User | The username used in connections attempts. |
| Password | The password used in connection attempts. |
| Row | Number of the current result row starting at 0. |
| Errno | Integer: error number of last database operation. |
| Error | String: error message of last database operation. |
| Halt_On_Error | One of "yes", "no", "report". If set to "yes" (the default), the database interface will report any errors and halt the program. If set to "report", the database interface will still report any errors, but continue reporting "false" back to the application, with Errno and Error set appropriately. If set to "no", the database interface will not report any errors, but silently report "false" back to application, with Errno and Error set appropriately. |
| Auto_Free | Boolean: In some DB interfaces a flag for early result memory release. |
| Debug | Boolean: If set, the database class will output all queries and additional diagnostic output. |
| type | Contant string: The name of the database interface, e.g. "mysql" or "oracle" |
| revision | Contant version string: The version of the database API (e.g. 1.2), NOT the CVS revision of the file implementing the API. |
| Sql_Table | string: The name of the table used by the nextid() API function. |
Internal instance variables