Bug #10246

Consecutive calls to setWhere don't work

Details

Doc Bug #10246	Consecutive calls to setWhere don't work
Submitted	2007-03-02 16:37 UTC
From	chris dot ramakers at gmail dot com
Assigned	quipo
Status	Closed
Package	MDB_QueryTool
PHP Version	4.4.3
Roadmaps	(Not assigned)

Comments

[2007-03-02 16:37 UTC] chris dot ramakers at gmail dot com

Description:
------------
In to documentation there is a reference to consecutive setWhere() calls to create one big where statement but actually the addWhere() method should be used to create big where statements

Test script:
---------------
$this->addWhere("username = '".$login."'");
$this->addWhere("password = '".md5($password)."'");

Expected result:
----------------
WHERE username = 'Blabla' AND password = 'az2e1a65ze13aze13a2z1ea365z1e3a2z1e6a5z1e3a2ze'

Actual result:
--------------
WHERE password = 'az2e1a65ze13aze13a2z1ea365z1e3a2z1e6a5z1e3a2ze'