[ANNOUNCEMENT] MDB_QueryTool-0.9.4-RC1 (beta) Released.

The new PEAR package MDB_QueryTool-0.9.4-RC1 (beta) has been released at http://pear.php.net/. Release notes ------------- - added UnitTest - new method getCol() which lets you retrieve just one column - getAll() takes an additional optional parameter, where you can define the method that should be used for firing the query - update() does also consider the value of setWhere() now when no primary column is given added a _buildUpdateQuery() for that too - bugfix in update, use fully qualified table name (Uwe Dörl) - bugfix in _buildSelectQuery, enclose column names by "" now Oracle should work and also reserved keywords can be used as column names (Uwe Dörl) - added some log functionality - added condition parameter to addWhereSearch - db field names are trimmed (no leading/trailing spaces) - Implemented datatype quoting: now it should autodetect the right MDB datatype before inserting the corresponding value in the db. Note that this can't be 100% right everytime, since it's based on an autodetection, but it's definitely an improvement over the previous versions, where everything was treated as 'text'. Package Info ------------- This package is an OO-abstraction to the SQL-Query language, it provides methods such as setWhere, setOrder, setGroup, setJoin, etc. to easily build queries. It also provides an easy to learn interface that interacts nicely with HTML-forms using arrays that contain the column data, that shall be updated/added in a DB. This package bases on an SQL-Builder which lets you easily build SQL-Statements and execute them. NB: this is just a MDB porting from the original DB_QueryTool written by Wolfram Kriesing and Paolo Panto (vision:produktion, wk@visionp.de). Related Links ------------- Package home: http://pear.php.net/package-info.php?package=MDB_QueryTool Changelog: http://pear.php.net/package-changelog.php?package=MDB_QueryTool Download: http://pear.php.net/get/MDB_QueryTool-0.9.4-RC1.tgz Authors ------------- Lorenzo Alberton <l.alberton@quipo.it> (lead)