Re: C++ cache MYSQL_RES

2008-09-12 Thread Warren Young
Kandy Wong wrote: Is there a way to cache the MYSQL_RES in C++? I've tried to develop a class with functions returning the MYSQL_RES, MYSQL_ROW and MYSQL_FIELDS. It sounds like you're trying to reinvent MySQL++: http://tangentsoft.net/mysql++/ -- Warren Young, maintainer of MySQL

C++ cache MYSQL_RES

2008-09-11 Thread Kandy Wong
Hi, Is there a way to cache the MYSQL_RES in C++? I've tried to develop a class with functions returning the MYSQL_RES, MYSQL_ROW and MYSQL_FIELDS. The functions work fine within the class file. But if I call the functions where else, I'll either get 'Segmentation fault' or 'bus error'. Any

Re: C++ cache MYSQL_RES

2008-09-11 Thread Peter M. Groen
: +31-71-5216317 Mobiel : +31-6-29563390 Email : [EMAIL PROTECTED] WWW : http://www.osdev.nl Skype : peter_m_groen On Friday 12 September 2008 00:56:06 Kandy Wong wrote: Hi, Is there a way to cache the MYSQL_RES in C++? I've tried to develop a class with functions returning

Re: MYSQL_RES ......

2005-02-20 Thread Mohsen Pahlevanzadeh
Dear Peter,Thanks for your guiding.I have implemented it.Thank from every member of this list too. Mohsen, The data structure you seem to be looking for is MYSQL_RES, the C API resultset, which is an array which is described in the manual page you were pointed to. It's pretty straightforward

RE: MYSQL_RES ......

2005-02-19 Thread Mohsen Pahlevanzadeh
Dears,I was attempping with your code.But it could't do my job. My job: I have list of my tables in my DB,i did it with mysql_list_tables() func. It returns MYSQL_RES type.But i don't know how to split it to an array. Please guide me.. Hi, I think you can find all the information you

Re: MYSQL_RES ......

2005-02-19 Thread Peter Brawley
Mohsen, The data structure you seem to be looking for is MYSQL_RES, the C API resultset, which is an array which is described in the manual page you were pointed to. It's pretty straightforward to use, eg ... MYSQL_RES *rset; ... if( mysql_real_query( conn, qry, strlen( qry ) == MYSQL_TRUE

MYSQL_RES ......

2005-02-18 Thread Mohsen Pahlevanzadeh
Dears,mysql_list_tables returns name of tables.(tables of a DB) It returns MYSQL_RES type. I want to split it to an array. I'm newbie in SQL,Please guide me. I'm working C. yours,Mohsen -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

RE: MYSQL_RES ......

2005-02-18 Thread mel list_php
); } printf(\n); } Maybe this is a good start point for you! From: Mohsen Pahlevanzadeh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: mysql@lists.mysql.com Subject: MYSQL_RES .. Date: Fri, 18 Feb 2005 16:44:06 -0800 (PST) Dears,mysql_list_tables returns name of tables.(tables of a DB) It returns

RE: What are MYSQL_RES limits ? -- update

2001-10-31 Thread M. A. Alves
Some other useful information on this problem: I have tried the operation in two other ways, both based on a version of the program with only one connection using the API and emiting the UPDATE statments on standard output: 1. output piped onto mysql -- failure :-( 2. output saved on a

What are MYSQL_RES limits ?

2001-10-30 Thread M. A. Alves
I seem to be hitting a ceiling in MYSQL_RES (mysql_use_result). I select 2 or 3 items but only 2295 are returned. What might be the cause of this? Thanks, -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351

What are MYSQL_RES limits ? -- update

2001-10-30 Thread M. A. Alves
On Tue, 30 Oct 2001, M. A. Alves wrote: I seem to be hitting a ceiling in MYSQL_RES (mysql_use_result). I select 2 or 3 items but only 2295 are returned. What might be the cause of this? The probable cause is I was accessing the same table at the same time (but thru different