-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hi,

neko cannot handle mysql stored procedures that returns results.
see details here :
http://dev.mysql.com/doc/refman/5.0/en/c-api-multiple-queries.html

here is an ugly hack allowing to handle stored procedures results :

Index: mysql.c
===================================================================
RCS file: /cvsroot/neko/libs/mysql/mysql.c,v
retrieving revision 1.17
diff -u -r1.17 mysql.c
- --- mysql.c     9 Jun 2006 10:04:47 -0000       1.17
+++ mysql.c     9 May 2007 09:07:04 -0000
@@ -383,6 +383,7 @@
                else
                        error(MYSQLDATA(o),val_string(r));
        }
+       mysql_next_result(MYSQLDATA(o));
        return alloc_result(res);
 }

@@ -431,7 +432,7 @@
        {
                MYSQL *m = mysql_init(NULL);
                value v;
- -               if(
mysql_real_connect(m,val_string(host),val_string(user),val_string(pass),NULL,val_int(port),val_is_null(socket)?NULL:val_string(socket),0)
== NULL ) {
+               if(
mysql_real_connect(m,val_string(host),val_string(user),val_string(pass),NULL,val_int(port),val_is_null(socket)?NULL:val_string(socket),CLIENT_MULTI_STATEMENTS)
== NULL ) {
                        buffer b = alloc_buffer("Failed to connect to
mysql server : ");
                        buffer_append(b,mysql_error(m));
                        mysql_close(m);




- --
kaalh
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGQZDuhc1MuvveZJwRAhStAJwN4UOsxkf7LUr9mPFiOfrJZN8jcgCfW77m
qgUA45Yxx6Mb5nMBKLMJrTE=
=b6Y1
-----END PGP SIGNATURE-----

-- 
Neko : One VM to run them all
(http://nekovm.org)

Reply via email to