Yes I could be interested. Could you send to me your diff? Thanks On 13 avr, 19:12, wiertel <[email protected]> wrote: > 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. > Seehttp://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/
