Example #1
0
 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);
 }