On Wed, 2010-03-10 at 16:18 +0200, Timo Sirainen wrote:
> > password_query = CALL user_pass_check('%n', '%d', '%w')
> >
> > user_query = CALL user_info('%n', '%d')
> >
> > This failed with the message:
> > User query failed: PROCEDURE imap.user_info can't return a result set
> > in the given context
>
> I thought it was possible to avoid that error by implementing the MySQL
> procedure in a specific way?.."Statements that return a result set can be used within a stored procedcure but not within a stored function. This prohibition includes SELECT statements that do not have an INTO var_list clause and other statements such as SHOW, EXPLAIN, and CHECK TABLE." Sounds like if you used SELECT .. INTO and returned those variables, it would work?
signature.asc
Description: This is a digitally signed message part
