/**
* 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;
}
