/** * return all record corresponding to the conditions stored into the * jDaoConditions object. * you can limit the number of results by given an offset and a count * @param jDaoConditions $searchcond * @param int $limitOffset * @param int $limitCount * @return jDbResultSet */ public final function findBy($searchcond, $limitOffset = 0, $limitCount = null) { $query = $this->_selectClause . $this->_fromClause . $this->_whereClause; if ($searchcond->hasConditions()) { $query .= $this->_whereClause != '' ? ' AND ' : ' WHERE '; $query .= $this->_createConditionsClause($searchcond); } $query .= $this->_createGroupClause($searchcond); $query .= $this->_createOrderClause($searchcond); if ($limitCount !== null) { $rs = $this->_conn->limitQuery($query, $limitOffset, $limitCount); } else { $rs = $this->_conn->query($query); } $this->finishInitResultSet($rs); return $rs; }
/** * return all record corresponding to the conditions stored into the * jDaoConditions object. * you can limit the number of results by given an offset and a count * @param jDaoConditions $searchcond * @param int $limitOffset * @param int $limitCount * @return jDbResultSet */ public final function findBy($searchcond, $limitOffset = 0, $limitCount = null) { $query = $this->_selectClause . $this->_fromClause . $this->_whereClause; if ($searchcond->hasConditions()) { $query .= $this->_whereClause != '' ? ' AND ' : ' WHERE '; $query .= $this->_createConditionsClause($searchcond); } $query .= $this->_createGroupClause($searchcond); $query .= $this->_createOrderClause($searchcond); if ($limitCount !== null) { $rs = $this->_conn->limitQuery($query, $limitOffset, $limitCount); } else { $rs = $this->_conn->query($query); } $rs->setFetchMode(8, $this->_DaoRecordClassName); return $rs; }