Patrick Calkins wrote:

{quote} Code:

$db = Zend_Db::factory('Mysqli', array(
    'host'     => '127.0.0.1',
    'username' => 'webuser',
    'password' => 'xxxxxxxx',
    'dbname'   => 'test'
));

$userName = 'jo';
$password = 'xyzzy';

$stmt = $db->prepare('CALL authenticate_user(?, ?)');
$stmt->bindParam(1, $userName);
$stmt->bindParam(2, $password);
$stmt->execute();
$result = $stmt->fetch();

The bindParam statements call _bindParam in Zend/Db/Statement/Mysqli.php, which have nothing more than a 'return true;' statement. It does not appear the Mysqli bind_param function is implemented - is this correct?? If so does anyone have any workarounds for using stored procedures in MySql 5.1??

Using the PDO_MYSQL driver does not help as it has a problem calling 2 stored procedures back-to-back (throws the 'SQLSTATE[HY000]: General error: 2014 Cannot execute queries while other unbuffered queries are active.' error, which has been discussed before)... {quote}

Zend_Db_Statement_MysqliTest tests bound parameters with regular queries but not with stored procedures.

Also check to see where else these tests should appear.