Re: Impossible Out Param Return Value

2010-05-26 Thread Peter Brawley
To: mysql@lists.mysql.com Subject: Impossible Out Param Return Value Using MySql 5.1, I have a very simple table with 1 row. I have a Stored Procedure to select if the row exists. I expect the test of this SP to return null, but it returns a value! The value is always returned if the '

Re: Impossible Out Param Return Value

2010-05-26 Thread Peter Brawley
Kevin WHERE (`id_file` = id_file AND `id_machine` = id_machine AND `id_user` = id_user How is MySQL supposed to distinguish `id_file` from id_file &c!? Name params diffferently from columns. PB - On 5/26/2010 9:07 AM, Kevin Baynes wrote: Using MySql 5.1, I have a very s

RE: Impossible Out Param Return Value

2010-05-26 Thread Kevin Baynes
07 AM To: mysql@lists.mysql.com Subject: Impossible Out Param Return Value Using MySql 5.1, I have a very simple table with 1 row. I have a Stored Procedure to select if the row exists. I expect the test of this SP to return null, but it returns a value! The value is always returned if the

Impossible Out Param Return Value

2010-05-26 Thread Kevin Baynes
Using MySql 5.1, I have a very simple table with 1 row. I have a Stored Procedure to select if the row exists. I expect the test of this SP to return null, but it returns a value! The value is always returned if the 'path' matches, regardless of the other values being tested. If the 'path' does