MySQL Forums
Forum List  »  General

Re: PREPARED Statement use in Query Browser (BUG?)
Posted by: Andrew Laughlin
Date: February 29, 2008 06:57PM

I'm having a similar issue. The statement below returns 'Query returned no resultset' in Query Browser, yet works fine from the command line (minus the transaction statements).


START TRANSACTION;
set @lst = "'Administrators', 'Users'";
set @sql = concat( 'select * from roles where RoleName in ( ', @lst, ' )' );
prepare statement from @sql;
execute statement;
COMMIT;

Options: ReplyQuote


Subject
Written By
Posted
Re: PREPARED Statement use in Query Browser (BUG?)
February 29, 2008 06:57PM


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.