I'm developing with a system that uses quite a few stored procedures
and i have run into a number of problems.
(I am using MYSQLI to connect.)
// login
if (isset($_POST['username']) && isset($_POST['password'])) {
$this->UserAccess->recursive = 1;
$sql = "CALL username('".$_POST['username']."', '".
$_POST['password']."')";
$res = $this->UserAccess->query($sql);
}
this is in my app_controller.php file, now the call works and returns
data if i debug($res);
but any query that is run after this call gives me:
Warning: SQL Error: 2014: Commands out of sync; you can't run this
command now in D:\www\race\cake\libs\model\datasources\dbo_source.php
on line 437
It seems it's not releasing the result set even though it returns a
result into $res
Any ideas?
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups "Cake
PHP" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---
