Bug #7642

Data type abstraction layer does not work not fetched results

Details

Request #7642	Data type abstraction layer does not work not fetched results
Submitted	2006-05-16 17:14 UTC
From	christian_rocher at hotmail dot com
Status	Open
Package	MDB_QueryTool
PHP Version	4.3.10
OS	Windows XP SP2
Roadmaps	(Not assigned)

Comments

[2006-05-16 17:14 UTC] christian_rocher at hotmail dot com

Description:
------------
Hi,

I use MDB2-2.0.1 with MDB2_Driver_mysql-1.0.1, MDB2_Driver_pgsql-1.0.0 and MDB_QueryTool-1.1.1 to connect to my databases (MySQL and Posgres).

The Data type abstraction layer works fine. But fetched records (QueryTool->getAll()) returns data in the database format. For example: a boolean is 0 or 1 for mysql and "f" or "t" for posgres.

Test script:
---------------
$this->QueryTool->reset();
$this->QueryTool->AddOrder( $this->QueryTool->primaryCol);
$this->QueryTool->getAll();

Expected result:
----------------
the bolean values are converted to 0 or 1

Actual result:
--------------
a boolean result is 0 or 1 for mysql and "f" or "t" for posgres.

[2006-05-16 17:16 UTC] christian_rocher at hotmail dot com

To be more specific: I talk about content of columns in results that does not work properly, it works for queries