| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 1.1.2 |
| Bug #3902 | package is not ready to work with primaryCol not int | ||
|---|---|---|---|
| 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) | ||
[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'
Comments
[2005-03-26 00:09 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send MANUAL CONFIRMATION IS NOT POSSIBLE. Write a message to pear-dev@lists.php.net to request the confirmation link. All bugs/comments/patches associated with this email address will be deleted within 48 hours if the account request is not confirmed!