Bug #3902

package is not ready to work with primaryCol not int

Details

Submitted	2005-03-21 16:36 UTC
From	marcin dot krzyzanowski at gmail dot com
Assigned	quipo
Status	Closed
Package	DB_QueryTool
PHP Version	5.0.2
OS	MacOS
Roadmaps	(Not assigned)

Comments

[2005-03-21 16:36 UTC] marcin dot krzyzanowski at gmail dot com

Description:
------------
DB_QueryTool is not ready to work with $primaryCol other
than "INT" because of brackets.

Reproduce code:
---------------
$primaryCol = "username";
.......

$data = array(
'username' => "'aaa'",
'password' => "bbb"
);
$authTable->update($data);

Expected result:
----------------
SELECT auth.username AS "username",auth.password AS
"password" FROM auth WHERE auth.username='aaa'
UPDATE auth SET
username='aaa',password='bbb)' WHERE
username='aaa'

similar with ->add then it produce "WHERE username=aaa"
instead "WHERE username='aaa'"

Actual result:
--------------
SELECT auth.username AS "username",auth.password AS
"password" FROM auth WHERE auth.username='aaa'
UPDATE auth SET
username='\'aaa\'',password='bbb)' WHERE
username='aaa'