ID: 35637
User updated by: realbenzin at inbox dot lv
Reported By: realbenzin at inbox dot lv
-Status: Feedback
+Status: Open
Bug Type: MySQLi related
Operating System: Win XP SP2
PHP Version: 5.1.1
New Comment:
Ok here is sp:
DELIMITER $$
DROP PROCEDURE IF EXISTS `vt_sys`.`spRazList` $$
CREATE PROCEDURE `spRazList`(r_id int unsigned)
BEGIN
SELECT
RAZ_ID,
RAZ_NOS,
RAZ_NMR,
RAZ_KONTA_NR
FROM
RAZOTAJS
WHERE
RAZ_ID = IFNULL(r_id,RAZ_ID);
END $$
DELIMITER ;
Previous Comments:
------------------------------------------------------------------------
[2005-12-12 07:53:53] [EMAIL PROTECTED]
How about showing how you defined the procedure?
------------------------------------------------------------------------
[2005-12-12 07:11:29] realbenzin at inbox dot lv
It is not the same!!!!! Because I am calling the sp twice and sp
contains only one select not two like in that other "bug". PS i red
about that multi query, but that won`t help me...
------------------------------------------------------------------------
[2005-12-11 23:30:56] [EMAIL PROTECTED]
Duplicate of bug #32882.
------------------------------------------------------------------------
[2005-12-11 23:22:07] realbenzin at inbox dot lv
5.0.15
------------------------------------------------------------------------
[2005-12-11 23:12:55] [EMAIL PROTECTED]
What mysql version are you connecting to?
------------------------------------------------------------------------
The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
http://bugs.php.net/35637
--
Edit this bug report at http://bugs.php.net/?id=35637&edit=1