Empty reply from db table


#1

Hi, this is a test function, bevaus I always get an error in the normal environment.
The error message is:
Undefined property: Cake\ORM\Query::$name [APP/Controller\JournalsController.php, line 237]
If I use ->get($id) instaed of find it works. Crazy I have many selections with find, but this is the first one not working. Any suggestions?

public function testCapital() {
$accTable = TableRegistry::get(‘Accounts’);
$acc = $accTable->find()
->where([‘account_no’ => “P1001”])
->where([‘year’ => 2017]);
echo $acc->name;

    return $this->redirect(['action' => 'index']);
}

#2

$acc is a query object, not an entity. Call ->first() to fetch the entity.


#3

if the query may return more records try toArray() or foreach

debug($acc);
debug($acc->toArray());

#4

Thanks for your help.
Now I am using a foreach loop and it is working fine.