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  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 31 + 37 = ?

 
 [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.