I have two stored procedure but when i call two stored procedure then given error comes:

"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]"

i'm using cakephp.
And my code is:

$city=$this->City->query('call CityMaster_SelectCityName');
$allAgents=$this->Admin->query('call WorkForceLoginMaster_SelectLoginName(0)');


What i do any simple solution.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.