/** * Find a creditor by its ID * * @param integer $id */ public function findCreditor($id) { $criteria = new Criteria(); $criteria->setTable('CRE'); $criteria->setSelect('NAAM' . "\t" . 'BNKIBAN'); $criteria->setWheres('NR'); $criteria->setOperators('='); $criteria->setValues($id); $criteria->setOrderBy('NR'); $criteria->setMaxResults(1); $criteria->setPageSize(20); $criteria->setPage(1); return $this->getResults($criteria); }