Re: stored procedure error is misleading

2005-04-07 Thread Michael Stassen
On Apr 7, 2005, at 2:37 PM, James Black wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am using mysql 5.0.3, running under Solaris 8, and I believe the error I am getting is not possible, but I don't know what I did wrong. I do: call assignItem('user', 1999, 97);// I get: ERROR 1172 (4200

re: stored procedure error is misleading

2005-04-07 Thread James Black
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I am using mysql 5.0.3, running under Solaris 8, and I believe the error I am getting is not possible, but I don't know what I did wrong. I do: call assignItem('user', 1999, 97);// I get: ERROR 1172 (42000): Result consisted of more than one row But