querry data with directFetch

[trungnq]

 I wanna querry data,I read in example and know the way:
   $HostObj = BizSystem::getObject("Pigs.Host.do.HostDO");
   $host = $HostObj->directFetch("[idPerson]='".$idPerson."'",1);
 with $idPerson knew.
   now,I get data with the way: $host[0]['idHost']
 But,when I try,I don't get data athought database have that data.
 I hope the help from everyone.
 Thanks very much.

[Openbiz.me]

If you want to query on id, you can use fetchById method. Other methods like fetchOne, fetchByName is handy as well.

Your syntax on directFetch looks ok. Can you check the SQL by turning on DEBUG?

Sent from my iPhone

[trungnq]

I have done this but not get data.
Have other ways to get data ?
Hope the help.
thanks

[Rocky Swen]

Can you dump you SQL query statement corresponding the directFetch method and find out the cause?