public function pageQuery() { $jane = DbObject::_getOne('PersonStuff', array('firstname' => 'Jane', 'lastname' => 'Doe')); $all = DbObject::_find('PersonStuff'); $this->assign('all', $all); $odd = DbObject::_findByWhere('PersonStuff', "id % 2 == 0", array()); $this->assign('odd', $odd); $sqled = DbObject::_findBySql('PersonStuff', "select id from person_stuff where firstname like 'J%'", array()); $this->assign('sqled', $sqled); $one = DbObject::_findOne('PersonStuff', array('firstname' => 'Jane')); $this->assign('one', $one); }