The below patch allows you to call MySQL stored procedures that return results by adding the CLIENT_MULTI_RESULTS flag to the call to mysql_real_connect(). For more information about this flag, see the MySQL documentation at:
http://dev.mysql.com/doc/refman/5.0/en/mysql-real-connect.html (search the page CLIENT_MULTI_RESULTS) Unless anyone thinks this is a bad idea, I'd like to have this patch included in the next Exim release. Bob --- exim-4.69-orig/src/lookups/mysql.c 2007-08-23 12:16:51.000000000 +0200 +++ exim-4.69/src/lookups/mysql.c 2008-03-20 17:43:04.000000000 +0100 @@ -202,7 +202,7 @@ if (mysql_real_connect(mysql_handle, /* host user passwd database */ CS sdata[0], CS sdata[2], CS sdata[3], CS sdata[1], - port, CS socket, 0) == NULL) + port, CS socket, CLIENT_MULTI_RESULTS) == NULL) { *errmsg = string_sprintf("MYSQL connection failed: %s", mysql_error(mysql_handle)); -- ## List details at http://lists.exim.org/mailman/listinfo/exim-dev Exim details at http://www.exim.org/ ##
