Re: mdb2 and datagrid

Mark Steudel wrote: > It doesn't look like it but is mdb2 result object supported by datagrid? No, it isn't. The reason is the same as why we deprecated the DB (actually is a DB_Result) DataSource: It is not efficient because most times too many records are queried and/or fetched. But we have the new Structures_DataGrid_DataSource_MDB2 for you, which is efficient because only the needed rows will be fetched. Usage: $dg->bind($sql, $options); - $sql is a SQL query - $options is an array of either one of the following forms: array('dbc' => [a MDB2 instance]) or array('dsn' => [a MDB2 dsn string or array]) Please note the 'GENERAL NOTES' section in the class doc block in the source code about (not) using ORDER BY in the SQL query (this is not yet in the manual, so please look into the source file). BTW: For people still using PEAR::DB and DB result objects with SDG, please have a look at Structures_DataGrid_DataSource_DBQuery. Regards, Mark