The documentation is wrong. The API for 5 hasn't been implemented yet - it still uses the 4.1.1/4.1.2 API.
See my other posts on performance etc (should be on both the bugs and Mysql lists). I suggest you download the latest 4.1.2 snapshot and work with that. Kevin Cowley R&D Tel: 0118 902 9099 (direct line) Email: [EMAIL PROTECTED] Web: http://www.alchemetrics.co.uk -----Original Message----- From: Ken Paradox [mailto:[EMAIL PROTECTED] Sent: 07 May 2004 18:13 To: [EMAIL PROTECTED] Subject: Two problems with prepared statements in ver 5.0.0 Hello, I have been working with the C API in version 4.1.1. I encountered a problem which I thought might be resolved in version 5.0.0, so I have loaded the RPMs for version 5.0.0 onto my development RedHat Linux system. --------------------------------------------------------- Problem 1 - can't link: According to documentation, many of the names of prepared statement functions have changed in version 5.0.0. I changed my C code to use the new names, but when I try to link, all of the new names are not found in the libraries. Here are some sample error message: sql.o: In function `MYSQL_ADD_PREP': sql.o(.text+0x1ac3): undefined reference to `mysql_stmt_init' sql.o(.text+0x1b2e): undefined reference to `mysql_stmt_prepare' sql.o(.text+0x1b7a): undefined reference to `mysql_stmt_result_metadata' sql.o(.text+0x1db6): undefined reference to `mysql_stmt_init' sql.o(.text+0x1e22): undefined reference to `mysql_stmt_prepare' sql.o(.text+0x1e6e): undefined reference to `mysql_stmt_param_count' sql.o(.text+0x2127): undefined reference to `mysql_stmt_bind_param' I had all of this working with version 4.1.1, except that I had a problem trying to use two different prepared statements alternately. --------------------------------------------------------- Problem 2 - mysql_stmt_result_metadata() returns int. According to documentation, this function should return a pointer to MYSQL_RES. In version 4.1.1, the previous function - named mysql_get_metadata - did work that way. But now I get a warning when I compile saying: coresql.c:183: warning: assignment makes pointer from integer without a cast --------------------------------------------------------- Is there something I am missing, or is this version not well tested for these features? Is anyone using this? Thanks, Ken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] ************************************************************************************** ALCHEMETRICS LIMITED (ALCHEMETRICS) Mulberry Park, Fishponds Road, Wokingham, Berkshire, RG41 2GX Tel: +44 (0) 118 902 9000 Fax: +44 (0) 118 902 9001 This e-mail is confidential and is intended for the use of the addressee only. If you are not the intended recipient, you are hereby notified that you must not use, copy, disclose, otherwise disseminate or take any action based on this e-mail or any information herein. If you receive this transmission in error, please notify the sender immediately by reply e-mail or by using the contact details above and then delete this e-mail. Please note that e-mail may be susceptible to data corruption, interception and unauthorised amendment. Alchemetrics does not accept any liability for any such corruption, interception, amendment or the consequences thereof. ************************************************************************************** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
