This class is a data source driver for the PEAR::MDB2 object
dbc: (object) A PEAR::MDB2 instance that will be used by this
driver. Either this or the 'dsn' option is required.
dsn: (string) A PEAR::MDB2 dsn string. The MDB2 connection will be
established by this driver. Either this or the 'dbc'
option is required.
You need to specify either a MDB2 instance or a MDB2 compatible dsn string as an option to use this driver.
If you use complex queries (e.g. with complex joins or with aliases), $datagrid->getRecordCount() might return a wrong result. For the case of GROUP BY, UNION, or DISTINCT in your queries, and for the case of subqueries, this driver already has special handling. However, if you observe wrong record counts, you need to specify a special query that returns only the number of records (e.g. 'SELECT COUNT(*) FROM ...') as an additional option 'count_query' to the bind() call.
You can specify an ORDER BY statement in your query. Please be aware that this sorting statement is then used in *every* query before the sorting options that come from a renderer (e.g. by clicking on the column header when using the HTML_Table renderer which is sent in the HTTP request). If you want to give a default sorting statement that is only used if there is no sorting query in the HTTP request, then use $datagrid->setDefaultSort().