Re: Retrieving results of a stored function using MySql C API

2009-04-16 Thread Moon's Father
function using MySql C API. Kindly let me know how to do so. In case you need details I'll share the source code. Cheers, Venu -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn

Retrieving results of a stored function using MySql C API

2009-04-15 Thread Venu Gopal
Hi guys, I am using stored procedures and stored functions for the first time. And currently stuck at a this point where. I am unable to retrieve results returned by stored function using MySql C API. Kindly let me know how to do so. In case you need details I'll share the source code. Cheers

MySQL C API: dedicated per-connections in the mutlithreading program

2006-09-08 Thread Andrew W. Nosenko
Sorry, but documentation on the MySQL C API say nothing about many interesting questions. The one of them: is it safe (or unsafe) to use non-MT client library (libmysqlclient.*, as opposite to the MT-aware libmysqlclient_r.*) for the multithreading programs in case when every parallel mysql

Re: MySQL C API: dedicated per-connections in the mutlithreading program

2006-09-08 Thread Philippe Poelvoorde
2006/9/8, Andrew W. Nosenko [EMAIL PROTECTED]: Sorry, but documentation on the MySQL C API say nothing about many interesting questions. The one of them: is it safe (or unsafe) to use non-MT client library (libmysqlclient.*, as opposite to the MT-aware libmysqlclient_r.*) for the multithreading

Re: MySQL C API: dedicated per-connections in the mutlithreading program

2006-09-08 Thread Andrew W. Nosenko
On 9/8/06, Philippe Poelvoorde [EMAIL PROTECTED] wrote: 2006/9/8, Andrew W. Nosenko [EMAIL PROTECTED]: Sorry, but documentation on the MySQL C API say nothing about many interesting questions. The one of them: is it safe (or unsafe) to use non-MT client library (libmysqlclient

FW: Mysql C API character set

2006-04-12 Thread He, Gang
From: He, Gang Sent: Wednesday, April 12, 2006 8:43 PM To: '[EMAIL PROTECTED]' Subject: Mysql C API character set Hi, I install MySQL server 4.1.12 in Redhat Linux in Japanese environment ( env LANG=ja_JP.UTF-8 ), I setup MySQL server utf8

MySQL C API: binding parameters to prepared statements

2006-02-09 Thread Kish Shen
Hi, I am trying to convert a Oracle 7 interface (from our Constraint Logic Programming Platform ECLiPSe) to MySQL. [I guess I should also say that I don't really have any experience with programming any database API previously, so please excuse me if this seems to be a basic question] The

Re: MySQL C API Version incompatibility

2005-08-11 Thread Warren Young
Sujay Koduri wrote: I was connecting to MySQL 5.0.4 through the C API and it was workign fine. But when I downgraded to MYSQL 4.1.13, the same code is giving the following error. Try rebuilding your program against the v4.1 APIs. -- MySQL General Mailing List For list archives:

MySQL C API Version incompatibility

2005-08-10 Thread Sujay Koduri
hi, I was connecting to MySQL 5.0.4 through the C API and it was workign fine. But when I downgraded to MYSQL 4.1.13, the same code is giving the following error. mysql_stmt_bind_result() failed Using unsupported buffer type: 0 (parameter: 1) I tried uninstalling all the existing mysql

MySQL C API problems

2005-03-25 Thread Andrew Prock
I'm having some difficulty with a program I wrote which uses the MySQL C api. I'm trying to migrate my server from version 4.0 to version 4.1. I have no difficulty connecting to the server using the mysql.exe command line utility, but when I try to connect from my program using the same

Re: MySQL C API problems

2005-03-25 Thread Michael Stassen
the 4.1 client library. Michael Andrew Prock wrote: I'm having some difficulty with a program I wrote which uses the MySQL C api. I'm trying to migrate my server from version 4.0 to version 4.1. I have no difficulty connecting to the server using the mysql.exe command line utility, but when I try

Re: MySQL C API problems

2005-03-25 Thread Andrew Prock
On Fri, 25 Mar 2005, Michael Stassen wrote: Password hashing was changed in 4.1 to improve authentication security, but this complicates backward compatibility. See the manual for details: http://dev.mysql.com/doc/mysql/en/old-client.html

Re: MySQL C API problems

2005-03-25 Thread Andrew Prock
On Fri, 25 Mar 2005, Andrew Prock wrote: On Fri, 25 Mar 2005, Michael Stassen wrote: Password hashing was changed in 4.1 to improve authentication security, but this complicates backward compatibility. See the manual for details: http://dev.mysql.com/doc/mysql/en/old-client.html

Where can I download The MySQL C API??

2005-01-25 Thread Shuva, Judith
Hi, I just downloaded mysql-essential-4.1.9-win32.msi, and as I understood, the C API supposes to be in here. Where exactly? I can't find it Thanks, __ Judith Shuva

RE: Where can I download The MySQL C API??

2005-01-25 Thread J.R. Bullington
, January 25, 2005 8:30 AM To: mysql@lists.mysql.com Subject: Where can I download The MySQL C API?? Hi, I just downloaded mysql-essential-4.1.9-win32.msi, and as I understood, the C API supposes to be in here. Where exactly? I can't find it Thanks

RE: Where can I download The MySQL C API??

2005-01-25 Thread Shuva, Judith
. Bullington [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 3:55 PM To: mysql@lists.mysql.com Cc: Shuva, Judith Subject: RE: Where can I download The MySQL C API?? http://dev.mysql.com/downloads/ Please note the section of Official APIs # Application Programming Interfaces (APIs

FW: Where can I download The MySQL C API??

2005-01-25 Thread J.R. Bullington
Here's a little more info for you. http://dev.mysql.com/doc/mysql/en/c.html J.R. -Original Message- From: Shuva, Judith [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 25, 2005 9:08 AM To: mysql@lists.mysql.com; J.R. Bullington Subject: RE: Where can I download The MySQL C API?? Hi

RE: Where can I download The MySQL C API??

2005-01-25 Thread Karam Chand
I am not sure what you mean by getting MySQL C API. The API are built in libmysql.lib and libmysql.dll or mysqlclient.lib. The header files are in include directory. Just include them in your project and start coding. Hope I was of help. Karam --- Shuva, Judith [EMAIL PROTECTED] wrote: Hi

RE: Where can I download The MySQL C API??

2005-01-25 Thread Ian Gibbons
On 25 Jan 2005 at 16:07, Shuva, Judith wrote: Hi J.R. Thanks for your answer. I saw that the API suppose to be in the MySQL server, so I downloaded mysql-essential-4.1.9-win32.msi, but after the installation, I can't find the API in the MySQL folder... Please, HELP! Hi, The MySQL

Program using MySQL C api crashes

2005-01-25 Thread Eric Lilja
Hello, I'm a newcomer to MySQL and to databases in general. I'm using MySQL 4.1.9 on a x86-system running Windows XP Pro SP2. I am trying to use the MySQL C api and I've made the following test program in C (hope the indentation isn't lost): #include mysql.h #include stdio.h #include stdlib.h

mySQL C++ API (which libraries)

2005-01-11 Thread Andy Ford
Hi fellow developers ... I'm about to move my Perl code to C++ for security. Which mySQL libraries are the best ones to use? There are so may available I thought I'd consult the community in the know! Thanks Andy -- perl -e print qq^bIG VeRN ! ^^qq^#'#Yv#=D+ ^ This e-mail is private and may

Re: mySQL C++ API (which libraries)

2005-01-11 Thread Karam Chand
The one supported by MySQL AB and the best till date is MySQL C API (well its best because I am C developer). It is the speediest too. I think you should find wrappers over the C API() over the net. If not then you can develop one for yourself and probably release it in GNU. Regards, Karam

MySQL C API questions

2004-12-06 Thread Mads Kristensen
Hi all. I'm using the MySQL C API to interface with my MySQL 4.1 server and I have the following questions: When I do a SELECT of some integer data value what is actually returned is a string representation of the integer value and since I need this integer value in my client I have to convert

RE: MySQL C API questions

2004-12-06 Thread Dave Juntgen
: Monday, December 06, 2004 3:32 PM To: [EMAIL PROTECTED] Subject: MySQL C API questions Hi all. I'm using the MySQL C API to interface with my MySQL 4.1 server and I have the following questions: When I do a SELECT of some integer data value what is actually returned is a string

Re: MySQL C API questions

2004-12-06 Thread Aftab Jahan Subedar
Hey check the MySQL C API By Example site. http://www.geocities.com/jahan.geo Yes you have to convert the data always and its zero terminated. Mads Kristensen wrote: Hi all. I'm using the MySQL C API to interface with my MySQL 4.1 server and I have the following questions: When I do a SELECT

Re: Static library for MySQL C API

2004-11-19 Thread Gleb Paharenko
? Regards, Karam --- Gleb Paharenko [EMAIL PROTECTED] wrote: Hello. See: http://dev.mysql.com/doc/mysql/en/Windows_client_compiling.html Karam Chand [EMAIL PROTECTED] wrote: Hello, Is it possible to get static library for MySQL C API() instead

Re: Static library for MySQL C API

2004-11-18 Thread Gleb Paharenko
Hello. See: http://dev.mysql.com/doc/mysql/en/Windows_client_compiling.html Karam Chand [EMAIL PROTECTED] wrote: Hello, Is it possible to get static library for MySQL C API() instead of libmysql.dll? Regards, Karam

Re: Static library for MySQL C API

2004-11-18 Thread Karam Chand
] wrote: Hello. See: http://dev.mysql.com/doc/mysql/en/Windows_client_compiling.html Karam Chand [EMAIL PROTECTED] wrote: Hello, Is it possible to get static library for MySQL C API() instead of libmysql.dll? Regards, Karam

Static library for MySQL C API

2004-11-17 Thread Karam Chand
Hello, Is it possible to get static library for MySQL C API() instead of libmysql.dll? Regards, Karam __ Do you Yahoo!? Meet the all-new My Yahoo! - Try it today! http://my.yahoo.com -- MySQL General Mailing List For list archives: http

Re: Help needed with MySQL C API-based client (segfault)

2004-09-05 Thread Aftab Jahan Subedar
have you tried ? http://www.geocities.com/jahan.geo/mysql_c_by_example.html Ruben Safir Secretary NYLXS wrote: On Fri, Sep 19, 2003 at 09:18:22AM +0500, Vikram Vaswani wrote: Hello, I need to write a simple C client for a project. I am using the MySQL C API. Attached is the code. It occassionally

Re: Help needed with MySQL C API-based client (segfault)

2004-09-04 Thread Ruben Safir Secretary NYLXS
On Fri, Sep 19, 2003 at 09:18:22AM +0500, Vikram Vaswani wrote: Hello, I need to write a simple C client for a project. I am using the MySQL C API. Attached is the code. It occassionally segfaults with no visible pattern. Could someone help me figure out why? Or any other comments

Re: mysql c-api 1064 mysql_real_query: issue with upgrade to 4.1.3

2004-08-28 Thread Aftab Jahan Subedar
Can you check the client version and server version from c api? you can copy paste it from (ehem) http://www.geocities.com/jahan.geo/mysql_c_by_example.html VY wrote: Hi, For some reason, all my sql queries fail with a 1064; These were all working under mysql-4.0 but had to upgrade to 4.1 so i

mysql c-api 1064 mysql_real_query: issue with upgrade to 4.1.3

2004-08-27 Thread VY
Hi, For some reason, all my sql queries fail with a 1064; These were all working under mysql-4.0 but had to upgrade to 4.1 so i could use nested subqueries i have attached a simple 10 line c-code as proof of concept. Obviously there is nothing wrong with the query... #include stdio.h

MySQL C API Examples

2004-08-26 Thread Aftab Jahan Subedar
I have arranged some MySQL C API examples at http://www.geocities.com/jahan.geo/mysql_c_by_example.html Comments/ Suggestion welcome. -- Aftab Jahan Subedar CEO/Software Engineer Subedar Technologies Subedar Baag Bibir Bagicha #1 North Jatrabari Dhaka 1204 Bangladesh http

MySQL C API license

2004-03-05 Thread Ronald J. Yacketta
Folks, What license does the MySQL C API fall under? I am looking to add client support to a game that I am creating, but need to know the terms of the license etc. -Ron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: MySQL C API license

2004-03-05 Thread Bernard Clement
To my knowledge it is GPL. Bernard On Friday 05 March 2004 17:52, Ronald J. Yacketta wrote: Folks, What license does the MySQL C API fall under? I am looking to add client support to a game that I am creating, but need to know the terms of the license etc. -Ron -- MySQL General

reg MySQL C API Prepared statements

2004-02-09 Thread Arunachalam
Hi! MySQL C API Prepareed statements routines; mysql_prepare, mysql_bind_param, mysql_fetch, mysql_execute are present in *libmysql.lib* file - right... I have currently used MySQL 4.0.17-max I want to clarify that starting from which version, MySQL provides

Re: reg MySQL C API Prepared statements

2004-02-09 Thread Egor Egorov
Arunachalam [EMAIL PROTECTED] wrote: Hi! MySQL C API Prepareed statements routines; mysql_prepare, mysql_bind_param, mysql_fetch, mysql_execute are present in *libmysql.lib* file - right... I have currently used MySQL 4.0.17-max I want to clarify

MySQL C API and unicode

2004-01-21 Thread Steel Bash
Hi all, I have an application that works fine with MySQL 3.23 and the C API (everything on Linux and only on Linux). I need now to support unicode (I mean chinese, japanese, russian... all kind of characters) so I am converting the application to use wchar_t and wstring instead of char and

Question on MySQL C API - Segfault on mysql_real_connect()

2004-01-20 Thread Deven Phillips
Hi, I have a program which calls a function which has an all-inclusive MySQL set of code (i.e. MySQL is initialized, used, and released within the span of the single function). The first time the function is called it function properly, but on subsequent calls, the function terminates with a

Re: Memory leaks using MySQL C Api

2004-01-19 Thread KKoTY
leaks using MySQL C Api Agreed, I am not calling mysql_store_result(). I attempted to add my_free() but the function does not seem to exist, it is also not listed in the API docs for the c api. As such it still seems that there should be no leak, but yet I do get one. Thanks for the idea

Re: Memory leaks using MySQL C Api

2004-01-18 Thread John McCaskey
Agreed, I am not calling mysql_store_result(). I attempted to add my_free() but the function does not seem to exist, it is also not listed in the API docs for the c api. As such it still seems that there should be no leak, but yet I do get one. Thanks for the idea anyway Chris, maybe you can

Re: Memory leaks using MySQL C Api

2004-01-17 Thread Chris Nolan
Hi! You're looking for the function my_free(). Enjoy! Regards, Chris John McCaskey wrote: I have the following code: //try the mysql connection mysql_init(mysql_connection); if(!mysql_real_connect(mysql_connection, db_host, db_user, db_pass, db_db, 0, NULL, 0)) {

Re: Memory leaks using MySQL C Api

2004-01-17 Thread Aftab Jahan Subedar
Hey wait a minute. Where did you get the my_free(), may be you are trying to say mysql_free(), but then that is used only if result set is used/called. But the code does not show any result set call. ie. mysql_use_result() or mysql_store_result(). So, the question now, how come there is a

Memory leaks using MySQL C Api

2004-01-16 Thread John McCaskey
I have the following code: //try the mysql connection mysql_init(mysql_connection); if(!mysql_real_connect(mysql_connection, db_host, db_user, db_pass, db_db, 0, NULL, 0)) { flockfile(stderr); fprintf(stderr, %s: Failed to connect to

Question about Mysql C API v 3.22 and 3.23

2004-01-12 Thread Joe Johnson
Hello, I am attempting a change in my use of mysql C API to use 3.23.54 instead of 3.21 and I am finding that the mysql_real_connect function is failing to run (it crashes the program). My mysqld version is also 3.22.27. Anyone know whether this is a bug in that version of the C API? Thank You

Re: Question about Mysql C API v 3.22 and 3.23

2004-01-12 Thread Paul DuBois
At 8:51 -0600 1/12/04, Joe Johnson wrote: Hello, I am attempting a change in my use of mysql C API to use 3.23.54 instead of 3.21 and I am finding that the mysql_real_connect function is failing to run (it crashes the program). My mysqld version is also 3.22.27. Anyone know whether this is a bug

Non-blocking MySQL C API calls?

2003-10-26 Thread Chris Nolan
Hi all, One feature that PostgreSQL has is non-blocking API calls. Admittedly, they don't have prepared statements yet, but non-blocking calls might be well worth having for an app I'm hoping to build. Does the MySQL API have this sort of capability? Regards, Chris -- MySQL General Mailing

mysql c api

2003-09-29 Thread Attila Soki
hi, i found a strange user comment in the current documentation of c api for mysql_real_connect. http://www.mysql.com/doc/en/mysql_real_query.html If a result set (MYSQL_RES) is in use, then mysql_free_result(...) must be called before a call to this function will be successful. if this is

Help needed with MySQL C API-based client (segfault)

2003-09-18 Thread Vikram Vaswani
Hello, I need to write a simple C client for a project. I am using the MySQL C API. Attached is the code. It occassionally segfaults with no visible pattern. Could someone help me figure out why? Or any other comments on the code to help me make it better? /* client.c */ #include stdio.h

Re: Help needed with MySQL C API-based client (segfault)

2003-09-18 Thread Ganbold
*/ mysql_free_result(result); } mysql_close(mysql); return 0; } At 09:18 AM 9/19/2003 +0500, you wrote: Hello, I need to write a simple C client for a project. I am using the MySQL C API. Attached is the code. It occassionally segfaults with no visible pattern. Could someone help me

MySQL C API

2003-09-10 Thread Håkan Medin
Hello All, I am trying to compile a Ansi-C program using the MYSQL_STMNT* mysql_prepare(...) function, but the function can't be found.. I have the following MySQL rpm's installed on my Linux machine, have I missed anyone? MySQL-client-4.0.14-0.i386.rpm MySQL-devel-4.0.14-0.i386.rpm

RE: MySQL C API

2003-09-10 Thread Tom Roos
whats the error u get? -Original Message- From: Håkan Medin [mailto:[EMAIL PROTECTED] Sent: 10 September 2003 10:31 To: [EMAIL PROTECTED] Subject: MySQL C API Hello All, I am trying to compile a Ansi-C program using the MYSQL_STMNT* mysql_prepare(...) function, but the function can't

RE: MySQL C API

2003-09-10 Thread Rick Robinson
Håkan- The prepared statement capability isn't available until 4.1 (I believe). Best of luck, Regards, Rick -Original Message- From: Håkan Medin [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 10, 2003 4:31 AM To: [EMAIL PROTECTED] Subject: MySQL C API Hello All, I am trying

Re: MySQL C API

2003-09-10 Thread Paul DuBois
At 10:30 +0200 9/10/03, Håkan Medin wrote: Hello All, I am trying to compile a Ansi-C program using the MYSQL_STMNT* mysql_prepare(...) function, but the function can't be found.. This function is one of those use for handling prepared statements. They're not available until 4.1, as indicated

MySql C API

2003-06-19 Thread Ronnie Arenas
Can anybody please list known Forums with regard to MySql C API programming and development, Interfacing with multi-language programming, COBOL, PHP, GDK+, XForms, etc... Help for newbies to C API, techniques, sample codes, creating wrappers, list of great reference books (ones

Re: Storing a BLOB in a MySQL database with the MySQL C API

2003-02-03 Thread Stephane Wirtel
i have a problem with my project :-) i created two functions, base64_encode, and base64_decode, to insert a binary file in a LONGBLOB field. When i use theses functions without a buffer i don't get errors. by example : OUTPUT = base64_decode(base64_encode(INPUT)); -- i don't have errors, i can

Storing a BLOB in a MySQL database with the MySQL C API

2003-02-02 Thread Stephane Wirtel
Hi all ! I would like to insert a Blob ( a picture exactly ), here is a small source code to test my insert. You can find 2 sources code, the first is to insert a blob in a table of a database ( this database exists in my MySQL server ) And the second code is to read this blob from the database.

Re: Storing a BLOB in a MySQL database with the MySQL C API

2003-02-02 Thread Paul DuBois
At 15:21 +0100 2/2/03, Stephane Wirtel wrote: Hi all ! I would like to insert a Blob ( a picture exactly ), here is a small source code to test my insert. You can find 2 sources code, the first is to insert a blob in a table of a database ( this database exists in my MySQL server ) And the

closing database (mysql C API)

2002-12-07 Thread Admin-Stress
Hi, I wrote an application using mysql C API. If I exit my application without closing database, will it be closed automatically? void error(int code) { printf(error: %d\n, code); exit(0); } int main() { ... error(-255); ... } How to pass the mysql database connector to a function

Re: closing database (mysql C API)

2002-12-07 Thread Paul DuBois
At 14:37 -0800 12/7/02, Admin-Stress wrote: Hi, I wrote an application using mysql C API. If I exit my application without closing database, will it be closed You don't close a database. What do you mean? Do you mean close the connection to the server? If so, exiting without closing

Help! problem using MySQL C API

2002-11-13 Thread Ganbold
Hi, I'm having trouble writing dial-up user billing software in C using MySQL C API. Program suppose to send query to mysql server and retrieve records and process those. It sends query for each class_id for every day and get records from ACCOUNTING table. While retrieving records it adds user

Re: Help! problem using MySQL C API

2002-11-13 Thread Shyamal Banerjee
Try using mysql_free_result each time after fetching the rows. SB - Original Message - From: Ganbold [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 4:27 PM Subject: Help! problem using MySQL C API Hi, I'm having trouble writing dial-up user billing

Re: MYSQL C++ API

2002-09-27 Thread Stefan Fleiter
Paco wrote: I'm having probles with the c++ api of mysql... could somebody help me plesae? Could be, maybe you should post your specific problem. - Before posting, please check: http://www.mysql.com/manual.php (the

Strange network error using mysql,mysql c api

2002-08-16 Thread Krata
Hi, i am using mysql c api to send some queries to mysql server which is on another computer (100MBit almost next to the client) in my code i am doing this if (mysql_real_query(mysql,query,strlen(query))) { fprintf(stderr,In query : \%s\\n,query

Strange network error using mysql,mysql c api

2002-08-16 Thread Krata
Hi, i am using mysql c api to send some queries to mysql server which is on another computer (100MBit almost next to the client) in my code i am doing this if (mysql_real_query(mysql,query,strlen(query))) { fprintf(stderr,In query : \%s\\n,query

Re: Strange network error using mysql,mysql c api

2002-08-16 Thread Victoria Reznichenko
Krata, Friday, August 16, 2002, 5:10:20 PM, you wrote: K Hi, K i am using mysql c api to send some queries to mysql server which is on K another computer (100MBit almost next to the client) K in my code i am doing this K if (mysql_real_query(mysql,query,strlen(query))) K { K

Re: Strange network error using mysql,mysql c api

2002-08-16 Thread Krata
On Fri, 16 Aug 2002, Victoria Reznichenko wrote: K do someone know what should be the problem? K Server is Win2K and has latest mysql server installed client is the one K from RedHat 7.3 (3.23.49) (=`mysql_config --version`) Do you always get this error or you got it just once? well i

Re: Strange network error using mysql,mysql c api

2002-08-16 Thread Gelu Gogancea
,mysql c api On Fri, 16 Aug 2002, Victoria Reznichenko wrote: K do someone know what should be the problem? K Server is Win2K and has latest mysql server installed client is the one K from RedHat 7.3 (3.23.49) (=`mysql_config --version`) Do you always get this error or you got it just

MySQL C API: Timeouts

2002-07-16 Thread Juerg Moser
Hi, I’m using the MySQL C API for my clients and MyISAM tables for the database (clients and server on W2k). I would now like to be sure that the client never hangs when inserting tuples into a table (using mysql_real_query()). This could happen if some other client holds (and doesn’t release

Mysql C API problems

2002-06-29 Thread Hugo Veiga
hi there the present serves for some clearing some doubts i have: 1 - if i wanna make an action based on the fact that a query i just made won't return results (empty set), how can i test that? will this do? if(!mysql_query(myData, query) { results = mysql_store_results(myData);

RE: Mysql C API problems

2002-06-29 Thread Dean Harding
1 - if i wanna make an action based on the fact that a query i just made won't return results (empty set), how can i test that? will this do? if(!mysql_query(myData, query) { results = mysql_store_results(myData); if(mysql_num_rows() == 0) { //action; } }

Re: Mysql C API problems

2002-06-29 Thread Georg Richter
On Saturday, 29. June 2002 11:15, Hugo Veiga wrote: Hello Hugo, will this do? if(!mysql_query(myData, query) { results = mysql_store_results(myData); -if(mysql_num_rows() == 0) +if (!mysql_num_rows(results)) { //action; } } with the above correction it should

A MySQL C++ API problem about Connection::close() Connection::purge()!

2002-04-30 Thread ???
In MySQL C++ API http://www.mysql.com/Downloads/mysql++/mysql++-1.7.1-win32-borland.zip , http://www.mysql.com/Downloads/mysql++/mysql++-1.7.1-1-win32-vc++.zip. The head file connection1.hh has two problems. 1. Function Connection::close() void close(void) { mysql_close(mysql); } 2. Function

FW: A MySQL C++ API problem about Connection::close() Connection::purge().

2002-04-30 Thread ???
In MySQL C++ API http://www.mysql.com/Downloads/mysql++/mysql++-1.7.1-win32-borland.zip , http://www.mysql.com/Downloads/mysql++/mysql++-1.7.1-1-win32-vc++.zip. The head file connection1.hh has two problems. 1. Function Connection::close() void close(void) { mysql_close(mysql); } 2. Function

Re: MySQL C API documentation

2002-03-26 Thread Konstantin Osipov
that You have reasons not to provide access for mysql_res-current_row, and I do store my own copy of current_row in Cursor. In the ~function, you don't have to call mysql_fetch_row(). mysql_free_result() will do this for you. But, according to MYSQL C API documentation, 8.4.2, (http://www.mysql.com

Re: MySQL C API documentation

2002-03-26 Thread Sinisa Milivojevic
Konstantin Osipov writes: * Michael Widenius [EMAIL PROTECTED] [02/03/26 12:41]: But, according to MYSQL C API documentation, 8.4.2, (http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#C_API_function_overview) I have to do this: An advantage of mysql_use_result

mingw, mysql c api, win2k cmd line error

2002-03-15 Thread David Thompson
I am having a heck of a time getting a simple c program up and running using mingw and the mysql c api. My makefile is simple enough I'm not sure what the -lm switch on the search compile line is for but I saw it in someone's makefile on the web so I through it in hoping it would work

!------ MySQL C API ----------!

2002-02-19 Thread Ron Stagg
I have a written a Windows client that accesses a MySQL server (Linux) via the MySQL C API. Stored in the MySQL database are large files (larger than a Mbyte). The C API makes it very easy for the client to query and alter the database. However, I have some special needs that don't appear

Re: Compile error. MySql C++ API

2002-02-16 Thread Sinisa Milivojevic
Vipul Kotecha writes: Hi List, I am new to the MySql C++ API and I am compiling one file it gives me error saying Error E2303 ..\..\include\sqlplus\resiter1.hh 56: Type name expected Error E2275 ..\..\include\sqlplus\resiter1.hh 56: { expected Error E2275 ..\..\include\sqlplus\resiter1

remote file processing with MySQL C API

2002-02-15 Thread Ron Stagg
I have a written a Windows client that accesses a MySQL server (Linux) via the MySQL C API. Stored in the MySQL database are large files (larger than a Mbyte). The C API makes it very easy for the client to query and alter the database. However, I have some special needs that don't appear

Compile error. MySql C++ API

2002-02-15 Thread Vipul Kotecha
Hi List, I am new to the MySql C++ API and I am compiling one file it gives me error saying Error E2303 ..\..\include\sqlplus\resiter1.hh 56: Type name expected Error E2275 ..\..\include\sqlplus\resiter1.hh 56: { expected Error E2275 ..\..\include\sqlplus\resiter1.hh 56: { expected and many

RE: Runtime error on MySQL C API

2002-02-12 Thread Maximiliano Lucius
Paul, SuSE has /etc/ld.so.conf That is working now. Thank for your time and help. M. - Original Message - From: Paul DuBois [EMAIL PROTECTED] To: Maximiliano Lucius [EMAIL PROTECTED] Sent: Monday, February 11, 2002 11:45 AM Subject: Re: Runtime error on MySQL C API Hi MySQL Builders

Re: is there a Solaris version of mysql++ c++ API

2001-12-20 Thread Sinisa Milivojevic
Uday Anumalachetty writes: Hi All, Is there a solaris version of Mysql++ API. I see some downloads under the solaris section but no Mysql++. Is there a patch that I need to install to make it work on Solaris? Thanks for your responses. Uday As long as you use GNU 2.95 and 3.0 series of

is there a Solaris version of mysql++ c++ API

2001-12-19 Thread Uday Anumalachetty
Hi All, Is there a solaris version of Mysql++ API. I see some downloads under the solaris section but no Mysql++. Is there a patch that I need to install to make it work on Solaris? Thanks for your responses. Uday - Before

Re: MySQL C API - Lost connection?

2001-11-25 Thread David Bouw
.. Regards, David - Original Message - From: Benjamin Charles Tehan [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Sunday, November 25, 2001 02:23 Subject: MySQL C API - Lost connection? I'm using MySQL 3.23.43 running on Linux with a 2.2.16 kernel. My software does around 50,000

Re: MySQL C API - Lost connection?

2001-11-25 Thread Benjamin Charles Tehan
inserts they result in: Lost connection to MySQL server during query The software is developed in C, using the mysql C api to talk to the database. Problem is.. once I get this error I'd assume I have lost connection to the database and that I would need to reconnect and try to insert

mysql c api

2001-09-04 Thread ahmed
hi all i hope that some one send me a programme illustrating how to access to mysql database with c api .. ahmed Portail mobile DIALY! visitez www.dialy.net DIALY! mobile portal visit www.dialy.net

Re: mysql c api

2001-09-04 Thread Carl Troein
ahmed writes: hi all i hope that some one send me a programme illustrating how to access to mysql database with c api .. ahmed Please don't repost just because you didn't like the answers you got the first time. Someone pointed you to C sources, and there are plenty of those available on

Re: mysql c api

2001-09-04 Thread Philip Mak
On Tue, 4 Sep 2001, ahmed wrote: i hope that some one send me a programme illustrating how to access to mysql database with c api .. I run a site that has a free e-mail forwarding service. The following program is what runs .qmail-default. #define HOST localhost #define USER username #define

Mysql C API Problem

2001-09-01 Thread BeachTHO
am connecting to a mysql server on localhost i put all the code in a function call mysql_conlocal MYSQL csql; int mysql_conlocal() { puts(Connecting to Mysql Server); if(!mysql_connect(csql,DBHOST,DBUSER,DBPASS)) { puts(Failure!); puts(This Could Because); puts(A Your Username or Password is

Re: Mysql C API Problem

2001-09-01 Thread Uwe Sander
just add mysql_init(csql); before accessing the struct for any purpose. Sure it helps (I made the same mistake, got the same result ;-) Uwe - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, September 01, 2001 8:25 PM Subject: Mysql C API Problem

mysql_insert_id()- MySQL C API

2001-07-23 Thread
Problem: INSERT fields AUTO_INCREMENT passes correctly, and call after that mysql_insert_id () all the same returns 0. Linux 2.2.14 operating system. Mysql version - 2.23.38

Re: mysql_insert_id()- MySQL C API

2001-07-23 Thread Benjamin Pflugmann
Hi. On Mon, Jul 23, 2001 at 04:32:54PM +0400, [EMAIL PROTECTED] wrote: Problem: INSERT fields AUTO_INCREMENT passes correctly, and call after that mysql_insert_id () all the same returns 0. Linux 2.2.14 operating system. Mysql version - 2.23.38 Hm. You know that the return value is of type

Borland CBuilder5 and mysql C api

2001-07-20 Thread Layton Morris
I have been trying for some months to use the C api with Borland builder, so far with only limited success. I can write a console application in the Builder environment, compile it, but not link it. The error says the library routines are not found. If I export the make file, edit it to

Unicode Support in MYSQL C -API

2001-07-05 Thread jofy chirayath
Sir/Madam, I am using MYSQL C-API to access MYSQL database . I am having problems when i gave Unicode support to my code, as the API functions accept parameters of the type const char * .With Unicode support the values being passed are the of the type unsigned short. Is there any way I can make

Re: MYSQL C API

2001-05-04 Thread VVM Ravikumar Sarma Chengalvala
Hi PAUL, 1.Thanks for the mail. 2.Regarding the return values I wonder anyone else has encountered other than the values -1,0 for mysql_query(). 3. I will try our the option suggested by you for mysql_real_connect(); 3. Another thing does mysql_api has any provision to send the error messages to

Re: MYSQL C API

2001-05-04 Thread Paul DuBois
At 3:03 PM +0100 5/4/01, VVM Ravikumar Sarma Chengalvala wrote: Hi PAUL, 1.Thanks for the mail. 2.Regarding the return values I wonder anyone else has encountered other than the values -1,0 for mysql_query(). You need to stop asking this question. The function is explicitly documented to say

MYSQL C API

2001-05-03 Thread VVM Ravikumar Sarma Chengalvala
Hi, 1. I am using C_API for accessing data from MYSQL. 2. mysql_query() function returns the following values: 0 if the query is successful -1 if the query fails. 3. At the same time mysql-C_API documentation specifies that it returns a non zero number if query is a failure.Does the function

Re: MYSQL C API

2001-05-03 Thread Paul DuBois
At 8:13 PM +0100 5/3/01, VVM Ravikumar Sarma Chengalvala wrote: Hi, 1. I am using C_API for accessing data from MYSQL. 2. mysql_query() function returns the following values: 0 if the query is successful -1 if the query fails. No. It returns 0 if the query is successful and NON-ZERO if it

  1   2   >