Hello everyone.

I'm just starting with mysql++ and I have a problem with a DELETE query:

-------------------------------------------------------------------------------------------------------------------------
mysqlpp::Connection db("CycomT", "localhost", "root", "");

mysqlpp::Query query = db.query();
query << "SELECT * FROM actions";
mysqlpp::Result result = query.store();
if (result) {
if (result.num_rows() != 0) {
try {
mysqlpp::Row row;
while (row = result.fetch_row()) {
std::cout << row["type"];
}
}
catch (mysqlpp::EndOfResults& er) {
//on ne fait rien
}
query.reset();
query << "DELETE FROM actions";
query.execute();
}
}


-----------------------------------------------------------------------------------------------------------------------------

The DELETE query seems to be executed before the SELECT query. Indeed my
table is'nt empty before, but my program doesn't print anything. Then,
my table is empty as expected. I don't understand why. Without the
DELETE query, my program prints the content correctly.

Sorry for my English,
Thanks for help

--
Muller Gael

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

Muller Gael wrote:
Add " << endl" or " << flush" to the end of this statement. IOStreams
will buffer output otherwise, making it difficult to determine which
order things actually happen in.

Add a cout statement in here (again, with a flush or newline).

Add one after this, too.

Do all that and try it again. It may be that things are not happening
in the order you think they are.

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