MySQL Forums
Forum List  »  Quality Assurance

Advanced Search
New Topic

Re: Cursor cannot explicitly SELECT more than one item of different type
Posted by: Thomas CORBIERE
Date: October 04, 2007 01:01AM

Hello,

This is not a bug, it's because you use a variable with the same name as the table field.
Variable name used in a query have priority hover column name.
Since your value variable has not been initialized, it effectively contains NULL,
and you are assigning this value to itself.

By using "SELECT *", you are not using the variable name in the query anymore.
That's why the problem is solved.

Regards,

Thomas CORBIERE

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Cursor cannot explicitly SELECT more than one item of different type
5208
Greg Dougherty
October 02, 2007 07:16PM
Re: Cursor cannot explicitly SELECT more than one item of different type
2523
Thomas CORBIERE
October 04, 2007 01:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.