On Apr 13, 6:38 pm, stéphane Herraiz <[email protected]> wrote: > Hi, > I want to use stored procedure (SELECT) but it doesn't work. > I have this message : Request error : 7 : 0A000 PROCEDURE > database.getdaydata can't return a result set in the given context > > My procedure is working, it is just a sql select... > I call it using this sql : CALL getdaydata(NOW()); > > If I use an INSERT or UPDATE stored procedure (without result), it's > working perfectly... > > Any idea?
I had the same problem. The reason turned to be that mysac opens database connection in mode that doesn't allow queries that could possibly return more than one dataset or sth. Stored procedure can contains many SELECTs and client must be prepared to handle that. See http://dev.mysql.com/doc/refman/5.0/en/c-api-multiple-queries.html - mysac does not set flag CLIENT_MULTI_RESULTS I coul'd post a diff with changes I've made to be able to use stored procedures but I don't think it as sollution. It's quick workaround at best. -- You received this message because you are subscribed to the Google Groups "APE Project" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/ape-project?hl=en --- APE Project (Ajax Push Engine) Official website : http://www.ape-project.org/ Git Hub : http://github.com/APE-Project/
