public function run() { //$this->_createNewMember(); //$this->_updateMember(); $Query = $this->model->query->select('first_name', 'last_name'); //$Query->whereEQ('id', 1); // work $Query->whereEQ('first_name', 'Pao'); // work $Query->whereEQ('last_name', 'IM', 'or'); // work $Query->whereNEQ('id', 3); // work //$Query->whereNULL('first_name'); // need to test //$Query->whereNNULL('first_name'); //not work //$Query->whereNNULL('id'); // ot work $Query->orderBy(array('last_name' => 'Desc', 'first_name' => 'Asc')); //$Query->groupBy('FieldA', 'FieldB'); //$Query->limit(); $DataList = $Query->run(); PrintUtil::display($DataList); }