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