search for: client_multi_result

...'%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 The root of this problem is that mysql_real_connect() needs to be called with option CLIENT_MULTI_RESULTS and mysql_next_result() called to retrieve extra results (that will not exist in the way that we use it). I attach a patch that fixes this problem -- the patch is against dovecot-1.2.10. This works for me ... but could probably do with testing by other people. BTW: I got the same problem with exi...

...in Solaris 10 which has MySQL version 4.0.31 bundled in. Since beta4 build fails due to change in src/lib-sql/driver-mysql.c. I've never used this feature but so I don't need it. This is just a FYI if someone reads mailing list. "driver-mysql.c", line 139: undefined symbol: CLIENT_MULTI_RESULTS "driver-mysql.c", line 448: warning: implicit function declaration: mysql_next_result Tomppa

...mysql5 stored procedure, but I only got an error message saying "ActiveRecord::StatementInvalid: Mysql::Error: PROCEDURE vc.testsp can''t return a result set in the given context: call testsp()" I found out from here: http://bugs.mysql.com/bug.php?id=2658 that mysql needs the flag CLIENT_MULTI_RESULTS set if you want to be able to return result sets from stored procedures. The problem is that mysql_adapter.rb doesn''t pass the flag parameter to the mysql connect function. When I hacked it in there myself, things worked perfectly. Am I going to about this the wrong way? Even though thin...

...ct': app_addon_sql_mysql.c:266: error: `CLIENT_MULTI_STATEMENTS' undeclared (first use in this function) app_addon_sql_mysql.c:266: error: (Each undeclared identifier is reported only once app_addon_sql_mysql.c:266: error: for each function it appears in.) app_addon_sql_mysql.c:266: error: `CLIENT_MULTI_RESULTS' undeclared (first use in this function) make[1]: *** [app_addon_sql_mysql.o] Error 1 make[1]: Leaving directory `/usr/src/asterisk/asterisk-addons-1.6.0-beta1' make: *** [all] Error 2 Earlier 1.4 addons are woking fine. Anybody have any idea about this error. Regards Keshav Regards...

...dures "is not yet implemented", but I was trying to get around the problem connecting like that: drv <- dbDriver("MySQL") con <- dbConnect(drv,user=MyUser, password=MyPasswd, dbname=MyDBName, host=MyHost, client.flag="196608" ) where 196608 is a combination of CLIENT_MULTI_RESULTS and CLIENT_MULTI_STATEMENTS as mentioned in the mysql_real_connect() documentation. Without these flags stored procedures calls do not run at all. I also do fetching the results in a loop - as suggested in the doc, so: doStoredProcedureFetch <- function( connection, sql ) { res <- dbS...

...age in Rails (using model calls to find_by_sql to get results) and tested successfully on Webrick on a windows box. I previously had a problem with returning data from a MySQL stored procedure (due to Activerecord''s MySQL connection adapter not passing the CLIENT_MULTI_STATEMENTS and CLIENT_MULTI_RESULTS flags in the connection options) but overcame this by hacking the ActiveRecord MySQL connection adapter and adding the required options to be passed to the mysql_real_connect call. I ported the application to a production Apache / Ubuntu server which runs Rails MySQL sites without problems (in...