Hello Mr Bader,
A simple answer to this solution, after all my own searches for a good
API to communicate with MySQL, I found nothing better than the standard
MySQL C API standard with MySQL. The calls are not at all cryptic, the
functionality is quite featureful (including escaping strings for mysql,
bless the MySQL team for adding something so simple) while having less
overhead than most of the C++ API's I've seen. And in truth, it's not
difficult to write a couple little classes which can encapsulate simple
functionality quite easily. I have made 2 such classes, which are quite
simple, not a significant ammount of error checking, or functionality, but
ResultSet's and Queries can be made.
If you are interested in my classes, I'd be happy to pack them up for you to
use, I only ask the headers be kept in the code.
My final jump onto the C API, was the extended documentation. The MySQL
team has documented it on the website very well, and you don't need to
install anything extra for the library, since it comes with MySQL.
Hope that helps,
-Shane
----- Original Message -----
From: "M. Bader" <[EMAIL PROTECTED]>
To: "mysql Mailing Liste" <[EMAIL PROTECTED]>
Sent: Monday, June 16, 2003 2:54 PM
Subject: Aborted Result in simple Query
> Hi all,
>
> this _my_ "simple" problem: I wrote a little c++ programm in linux using
> the plusplus api
>
> My purpose was to create a simple interface to mysql. Programmer uses my
> class, gives a sql-string and gets a pointer to the result array wich my
> class creates out of the result set.
>
> this is a shortened part of my scripts:
> [...]
> Query* q = new Query(&conn);
> [...]
>
> bool myConn::runQuery(char *sql)
> {
> (*q) << sql;
> cout << q->preview() << endl;
> cout << "one" << endl;
> Result res = q->store();
> cout << "two" << endl;
> [...]
> }
>
> and the following is the output:
> [...]
> SELECT name FROM test;
> one
> Aborted
>
> ...that's it.
>
> If I try to get out what's wrong by
> try{ [...] }
> catch(BadQuery er) { cout << er.error; }
>
> i'll only receive cryptic symbols (like a misplaced pointer)
>
> So here are my questions:
> 1. Is there any way to get out correctly what's wrong?
> 2. Is there any good(!) description of the mySQL C++ API?
> (http://www.mysql.com/documentation/mysql++/index.html is horrific!)
>
> Best regards
>
> M. Bader
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
