Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 1.2.3

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 Assigned:
Status: Open Package: MDB_QueryTool
PHP Version: 4.3.10 OS: Windows XP SP2
Roadmaps: (Not assigned)    
Subscription  
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes. If this is not your bug, you can add a comment by following this link. If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
2006-05-16 17:44 UTC
Package:
Bug Type:
Summary:
From: christian_rocher at hotmail dot com
New email:
PHP Version: Package Version: OS:

 

 [2006-05-16 17:14 UTC] christian_rocher at hotmail dot com (Christian Rocher)
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.

Comments

 [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
 [2006-05-16 17:44 UTC] lsmith (Lukas Smith)
if at all this is a feature request .. currently MDB_Querytool does not support passing in types as parameters. as a result MDB/MDB2 cannot do the type conversion.