Hi,
I am using mysql++ very lightly..connect to a DB, run a
select/insert/update and use the result set. Now I have 2 things I
want to do...One I want to figure how to keep the connection always on
and be able to check if the connection has disconnected and if so,
then connect to the db again.

Is it a big overhead to keep connecting every 1/2 a sec or so? If
it is then I would like to have this feature where I can probably set
a idle time out and be able to check of the connection is down.

Also how do I get how many filed are returned by a select * from
query. I know how to get how many rows, but the col number and names,
how do I get that?

I have few other questions which I will send in a seperate email once
I am alittle clear as to what I want to do.

Thanks a ton

AS

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw

Ankur G35 Saxena wrote:
Use Connection:ing(). Here's why:

http://dev.mysql.com/doc/mysql/en/mysql-ping.html

Are you asking us to guess what the results of your benchmark testing
will be? That's a poor substitute for actually doing the tests...

Look at the value_list() and field_list() member functions. See also
the fieldinf1 and dbinfo examples.

Please avail yourself of the manual first:

http://tangentsoft.net/mysql++/doc/

Two of the questions you've already asked are already addressed there.

--
MySQL++ Mailing List
For list archives: http://lists.mysql.com/plusplus
To unsubscribe: http://lists.mysql.com/plusplus?unsu...ie.nctu.edu.tw