Package Information: MDB_QueryTool
| » Version | » Information |
|---|---|
| 1.2.3 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-1.2.3 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-1.2.3 Release date: 2012-04-11 23:03 UTC Release state: stable Release uploaded by: doconnor Changelog: QA release - fixed bug #12905: add() doesn't return the id of the inserted row when using MDB2 and no primaryCol - fixed bug #13307: wrong fieldname case with oracle - fixed bug #13308: do not rely on autoload (PHP4 fix) - fixed bug #13694: quoting identifiers is not working with CAST() - fixed bug 14160: INSERT Fails with MDB2 under certain circumstances - fixed bug #14862: Call to undefined method MDB_Error::tableinfo() [doconnor] - Bug #13388 ->add with mdb2 and mysql v5.0 - Bug #14863 Fatal error: Call to a member function quoteIdentifier() on a non-object - #14943 setSelet or addSelect incorrectly quotes function expression - Bug #19217 get unit tests working - Bug #19218 _localeSafeImplode() broken for NULL / empty strings Dependencies: |
| 1.2.2 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-1.2.2 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-1.2.2 Release date: 2008-01-12 08:12 UTC Release state: stable Release uploaded by: quipo Changelog: - fixed bug #12353: identifier quoting with functions in _buildSelect() - better identifier quoting in _buildFrom() - Coding Standards fixes Dependencies: |
| 1.2.1 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-1.2.1 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-1.2.1 Release date: 2008-01-12 05:45 UTC Release state: stable Release uploaded by: quipo Changelog: - fixed bug #9963: Quoting problem with COUNT(*) - fixed bug #10073: bug with empty() and 0 in _localeSafeImplode() - fixed bug #10890: warning with addMultiple() when no PRIMARY KEY is set - Coding Standards fixes Dependencies: |
| 1.2.0 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-1.2.0 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-1.2.0 Release date: 2007-01-27 14:13 UTC Release state: stable Release uploaded by: quipo Changelog: - added getOne() method (request #7580) - custom implementation of implode() to circumvent locale handling of floats, which clashes with SQL standards (thanks to Lukas Ruetz) - fixed bug #7909: different names for nextId()/nextID() in MDB and MDB2 - request #8056: add support for NULL fields in remove() - fixed bug #8319: add $options['idxname_format'] to connect() to bypass MDB2 default index format - added save() method to MDB_QueryTool_Result_Row (Elmar) - fixed handling of returned values in MDB_QueryTool_Result - added getFirst(), getNext() and hasMore() methods to MDB_QueryTool_Result_Object - added support for custom return classes (Elmar) - added table and field name quoting (requests #4613, #5250, #7570, #9197) (Elmar) - fixed bug #9734, an incorrect regexp adds extraneous table names to the fields, if the name of the field appears as a column name in the current table. - added new tests - switched to package.xml v2 Dependencies: |
| 1.1.1 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-1.1.1 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-1.1.1 Release date: 2006-05-01 11:50 UTC Release state: stable Release uploaded by: quipo Changelog: - fixed MDB_QueryTool_Result_Object::fetchRow() when the return type is a scalar value instead of an array (bug #7532) Dependencies: |
| 1.1.0 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-1.1.0 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-1.1.0 Release date: 2006-04-08 06:46 UTC Release state: stable Release uploaded by: quipo Changelog: - added MDB2 support. Just set $MDBversion = 2 as the third parameter of the constructor, and QueryTool will use MDB2 as the backend instead of MDB (thanks to Lukas Smith). Dependencies: |
| 1.0.2 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-1.0.2 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-1.0.2 Release date: 2006-01-26 14:14 UTC Release state: stable Release uploaded by: quipo Changelog: - changed license to BSD - fixed bug with big integers being incorrectly trimmed Dependencies: |
| 1.0.1 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-1.0.1 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-1.0.1 Release date: 2005-09-08 13:43 UTC Release state: stable Release uploaded by: quipo Changelog: - added support for INNER JOINs (req #3842) - fixed bug #3842, using the addJoin/setJoin methods causes an "invalid token" error with ibase; the joined table columns aliases are now named in this format: "t_tablename_fieldname" instead of "_tablename_fieldname". Only the ibase driver is affected by this change. - fixed notice (bug #3925) - fixed pass-by-reference error with PHP 5.1 (thanks to Dmitry Shirokov) - added new tests Dependencies: |
| 1.0.0 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-1.0.0 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-1.0.0 Release date: 2005-03-03 11:05 UTC Release state: stable Release uploaded by: quipo Changelog: - fixed bug #3290, getCount() method returns zero when using an offset (patch by kubo at isite dot co dot jp) - fixed bug #3518, Error in _quote when you use raw option = true - strings lenghtier than the column max size are truncated to prevent db errors - using setOrder() with setGroup()+setHaving() could cause a malformed query - fully tested with MySQL, PostgreSQL and Firebird/Interbase (added a new testsuite using SimpleTest) Dependencies: |
| 0.11.1 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-0.11.1 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-0.11.1 Release date: 2004-10-18 11:17 UTC Release state: stable Release uploaded by: quipo Changelog: - allow multiple left|right join clauses. NB: getJoin($type) now returns array( $joinTable1 => $joinOnClause1, $joinTable2 => $joinOnClause2, ) - allow class usage without instanciating a db object (to use the class as a simple query builder) - unset non-specific PEAR::DB options before calling connect() (bug #1614) - allow reuse of existing connection (bug #2007), thanks to eln at gmx dot net Dependencies: |
| 0.10.1 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-0.10.1 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-0.10.1 Release date: 2004-05-05 04:02 UTC Release state: stable Release uploaded by: quipo Changelog: - changed useResult() method; now it accepts a $type parameter, use it to return 'array' results or 'object' results (thanks to Roman Dostovalov). Please note that BC is maintained, useResult(true) will default to useResult('array'), and useResult(false) will default to useResult('none'). - fixed problems with useResult(true) and empty results - when using useResult(true), if the user doesn't call getFirst() on the first iteration, the class does so automatically Dependencies: |
| 0.9.7 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-0.9.7 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-0.9.7 Release date: 2004-03-19 08:06 UTC Release state: stable Release uploaded by: quipo Changelog: - on UPDATE, field names are no more prefixed by the table name - added an $options parameter to connect() - fix bug #284 (Log::factory() needs to return a reference) - fix bug #298 (reset() does not reset limit) - fix bug #322 (undefined var $autoConnect) - PHP 5 fixes - fixes to the testsuite Dependencies: |
| 0.9.6 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-0.9.6 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-0.9.6 Release date: 2003-09-23 13:29 UTC Release state: stable Release uploaded by: quipo Changelog: - added new method getQueryString() which returns the rendered query - added setDbInstance() which lets you supply an existing MDB-instance to work with using this you dont need to pass a DSN to the constructor! - use Log 1.7 API - addWhereSearch now only prefixes known columns as it is supposed to be - make setLimit also work to unset it Dependencies:
|
| 0.9.5-pl1 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-0.9.5-pl1 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-0.9.5-pl1 Release date: 2003-06-17 19:49 UTC Release state: stable Release uploaded by: quipo Changelog: [ I was too quick :p ] - added missing bugfix in addHaving and unit test, thanks to Johannes Schäfer Dependencies:
|
| 0.9.5 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-0.9.5 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-0.9.5 Release date: 2003-06-17 19:30 UTC Release state: stable Release uploaded by: quipo Changelog: - bugfix when writing log files, times were wrong - bugfix in EasyJoin, which added unnecessary conditions - bugfix in building column alias which is at the end of the string - bugfix in addMultiple() which didnt work without primaryCol - bugfix in addHaving, thanks to Johannes Schäfer Dependencies:
|
| 0.9.4 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-0.9.4 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-0.9.4 Release date: 2003-06-09 20:09 UTC Release state: stable Release uploaded by: quipo Changelog: - added set/getLimit(), which set the limit globally, getAll() and getCol() can still overwrite this temporarily - added addOrder() - added *Having() methods by Johannes Schaefer - fix bug in building group clause for getCount() - bug fix in building join Dependencies:
|
| 0.9.4-RC1 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-0.9.4-RC1 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-0.9.4-RC1 Release date: 2003-05-24 13:29 UTC Release state: beta Release uploaded by: quipo Changelog: - 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'. Dependencies:
|
| 0.9.3 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-0.9.3 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-0.9.3 Release date: 2003-02-20 23:40 UTC Release state: beta Release uploaded by: quipo Changelog: - fixed stupid connection bug (my bad :p) - other minor fixes/updates Dependencies:
|
| 0.9.2 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-0.9.2 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-0.9.2 Release date: 2003-02-10 13:45 UTC Release state: beta Release uploaded by: quipo Changelog: - fixed missing custom sequence name handling - enhancing the constructor to take the error/log callbacks |
| 0.9 |
Easy InstallNot sure? Get more info. pear install MDB_QueryTool-0.9 Pyrus InstallTry PEAR2's installer, Pyrus. php pyrus.phar install pear/MDB_QueryTool-0.9 Release date: 2003-01-28 14:01 UTC Release state: beta Release uploaded by: quipo Changelog: - initial release in PEAR |