zakmail007
01-10-2012, 12:53 PM
Hello guys,
i have a problem where i am trying to execute the following queries in my controller using cake php:
$city=$this->City->query('call CityMaster_SelectCityName');
$allAgents=$this->Admin->query('call WorkForceLoginMaster_SelectLoginName(0)');
and it results to "Warning (512): SQL Error: 2014: Commands out of sync; you can't run this command now [CORE/cake/libs/model/datasources/dbo_source.php, line 684]
Query: call WorkForceLoginMaster_SelectLoginName(0) "
i would really appreciate it if any one can tell me why this is happening and how to solve it!
i have a problem where i am trying to execute the following queries in my controller using cake php:
$city=$this->City->query('call CityMaster_SelectCityName');
$allAgents=$this->Admin->query('call WorkForceLoginMaster_SelectLoginName(0)');
and it results to "Warning (512): SQL Error: 2014: Commands out of sync; you can't run this command now [CORE/cake/libs/model/datasources/dbo_source.php, line 684]
Query: call WorkForceLoginMaster_SelectLoginName(0) "
i would really appreciate it if any one can tell me why this is happening and how to solve it!