-----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, there is only one row possible, as the rid is unique.
I am wondering if there is something obvious I missed.
Thanx.
mysql> CREATE PROCEDURE assignItem (
-> user CHAR(15),
-> rid int,
-> start int)
-> BEGIN
-> DECLARE itemtype CHAR(13);
-> DECLARE curusecount INT DEFAULT 0;
-> SELECT itemtype INTO itemtype FROM items WHERE rid=rid;
-> END;//
SELECT itemtype FROM items WHERE rid=1999;//
+----------+
| itemtype |
+----------+
| PC |
+----------+
mysql> describe items;//
+----------+----------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------+----------+------+-----+---------+----------------+
| rid | int(11) | NO | PRI | NULL | auto_increment |
| lid | int(11) | NO | MUL | 0 | |
| itemtype | char(4) | NO | MUL | | |
| label | char(12) | NO | UNI | | |
| status | char(1) | NO | | | |
| layoutx | int(11) | YES | | NULL | |
| layouty | int(11) | YES | | NULL | |
| theta | int(11) | YES | | NULL | |
+----------+----------+------+-----+---------+----------------+
- --
"Love is mutual self-giving that ends in self-recovery." Fulton Sheen
James Black [EMAIL PROTECTED]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFCVX3qikQgpVn8xrARAjUHAJ4xvgPiGge494hydhmzCfnLuyasegCcDEqk
94SdQEwxIdqFlktjGDWmySY=
=3ciU
-----END PGP SIGNATURE-----
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
