Example #1
0
 /**
  * Launch a SQL Query with limit parameter, so it returns only a subset of a result
  * @param   string   $queryString   the SQL query
  * @param   integer  $limitOffset   the offset of the first row to return
  * @param   integer  $limitCount    the maximum of number of rows to return
  * @return  jDbResultSet|boolean  SQL Select. False if the query has failed.
  */
 public function limitQuery($queryString, $limitOffset, $limitCount)
 {
     $this->lastQuery = $queryString;
     if ($this->_debugMode) {
         $log = new jSQLLogMessage($queryString);
         $result = $this->_doLimitQuery($queryString, intval($limitOffset), intval($limitCount));
         $log->endQuery();
         $log->setRealQuery($this->lastQuery);
         jLog::log($log, 'sql');
         return $result;
     } else {
         return $this->_doLimitQuery($queryString, intval($limitOffset), intval($limitCount));
     }
 }