From 3392e51b4edf84682b66ce9e32d00c1adb3205bb Mon Sep 17 00:00:00 2001 From: wei <> Date: Tue, 8 May 2007 07:49:50 +0000 Subject: Fixed sqlmap query with limit and offsets. --- framework/Data/SqlMap/Statements/TMappedStatement.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) (limited to 'framework/Data/SqlMap/Statements/TMappedStatement.php') diff --git a/framework/Data/SqlMap/Statements/TMappedStatement.php b/framework/Data/SqlMap/Statements/TMappedStatement.php index e56e73ce..db02857f 100644 --- a/framework/Data/SqlMap/Statements/TMappedStatement.php +++ b/framework/Data/SqlMap/Statements/TMappedStatement.php @@ -203,7 +203,7 @@ class TMappedStatement extends TComponent implements IMappedStatement */ public function executeQueryForList($connection, $parameter, $result=null, $skip=-1, $max=-1, $delegate=null) { - $sql = $this->_command->create($this->_manager, $connection, $this->_statement, $parameter); + $sql = $this->_command->create($this->_manager, $connection, $this->_statement, $parameter,$skip,$max); return $this->runQueryForList($connection, $parameter, $sql, $result, $skip, $max, $delegate); } @@ -228,7 +228,9 @@ class TMappedStatement extends TComponent implements IMappedStatement $registry=$this->getManager()->getTypeHandlers(); $list = $result instanceof ArrayAccess ? $result : $this->_statement->createInstanceOfListClass($registry); - $reader = $this->executeSQLQueryLimit($connection, $sql, $max, $skip); + $connection->setActive(true); + $reader = $sql->query(); + //$reader = $this->executeSQLQueryLimit($connection, $sql, $max, $skip); if(!is_null($delegate)) { foreach($reader as $row) -- cgit v1.2.3