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

2009-04-16 Thread Moon's Father
nction 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. C

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 l

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.*) f

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

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 s

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 inte

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: http://lists.

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 rpm's

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: > >

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: > >

Re: MySQL C API problems

2005-03-25 Thread Michael Stassen
ink your app against 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 u

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 usin

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 #include #incl

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, Th

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" <[

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?

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

2005-01-25 Thread Shuva, Judith
: J.R. 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

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 T

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: 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 (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#=http://lists.mysql.com/mysql To unsubs

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 SELE

RE: MySQL C API questions

2004-12-06 Thread Dave Juntgen
TED] > Sent: 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 integ

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 co

Re: Static library for MySQL C API

2004-11-19 Thread Gleb Paharenko
gt; Karam Chand <[EMAIL PROTECTED]> wrote: >> > Hello, >> > >> > Is it possible to get static library for MySQL C >> API() >> > instead of libmysql.dll? >> > >> > Regards, >> >

Re: Static library for MySQL C API

2004-11-18 Thread Karam Chand
TED]> 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() &g

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? >

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 ot

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 c

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 #include #

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

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. > > -Ro

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: 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

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 this

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 stri

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 segme

Re: Memory leaks using MySQL C Api

2004-01-19 Thread KKoTY
]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Sunday, January 18, 2004 8:31 AM Subject: Re: Memory 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 liste

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 cla

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 leak

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)) {

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 t

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

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

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 tru

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

2003-09-18 Thread Ganbold
{ fprintf(stderr, "Error in reading result set: %s\n",mysql_error(mysql)); } } } /* clean up */ mysql_free_result(result); } mysql_close(mysql); return 0; } At 09:18 AM 9/19

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 #include

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 here

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 tryi

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&#

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 MySQL-serv

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 th

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 c

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 secon

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: 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 wit

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

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

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

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 m

MYSQL C++ API

2002-09-27 Thread Paco
I'm having probles with the c++ api of mysql... could somebody help me plesae? -- --Paco "Open Source, Open Mind" "Slackware, sending kiddies to /dev/null, since 1993" - Before posting, please check: http://www.mysql.co

Re: Strange network error using mysql,mysql c api

2002-08-16 Thread Gelu Gogancea
ugust 16, 2002 8:19 PM Subject: Re: Strange network error using mysql,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 > >

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?

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,st

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\

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\

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) a

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

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;

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);

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. Func

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. Func

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

Re: MySQL C API documentation

2002-03-26 Thread Konstantin Osipov
t the future if you in the class > cursor stored the value from mysql_fetch_row and returned this in your 'row' > function, instead of relying on mysql->current_row. I've realised eventually that You have reasons not to provide access for mysql_res->current_row, and I do s

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

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

!------ 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 appe

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 E22

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

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 appe

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

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 se

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 pos

Re: MySQL C API - Lost connection?

2001-11-25 Thread Benjamin Charles Tehan
6 kernel. > > > > My software does around 50,000 inserts a day and from some of those 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 > > data

Re: MySQL C API - Lost connection?

2001-11-25 Thread David Bouw
fell away.. 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

MySQL C API - Lost connection?

2001-11-25 Thread Benjamin Charles Tehan
I'm using MySQL 3.23.43 running on Linux with a 2.2.16 kernel. My software does around 50,000 inserts a day and from some of those 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. Probl

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" #d

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

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 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 Subj

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 Passwo

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

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

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 includ

Unicode Support in MYSQL C -API

2001-07-04 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

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 sa

  1   2   >