public function limit($sqlQuery, $number)
{
$offset = 0;
if (is_array($number)) {
if (isset($number[1])) {
$offset = intval(trim($number[1], $this->_escapeChar));
}
$limit = intval(trim($number[0], $this->_escapeChar)) + $offset;
} else {
$limit = intval(trim($number, $this->_escapeChar));
}
$sqlQuery = sprintf('SELECT * FROM (SELECT Z1.*, ROWNUM PHALCON_RN FROM (%s) Z1', $sqlQuery);
if (0 != $limit) {
$sqlQuery .= sprintf(' WHERE ROWNUM <= %d', $limit);
}
$sqlQuery .= ')';
if (0 != $offset) {
$sqlQuery .= sprintf(' WHERE PHALCON_RN >= %d', $offset);
}
return $sqlQuery;
}