I have a Fedora Linux box that I just upgraded from FC3 to FC6. This code
worked fine under FC3 (it would show me all of the times in the "items"
database. The code is at the end of the email. Under FC6 I am receiving a
pqxx::sql_error message which has my select statement in it. If I do that
select statement from psql it works fine. Any ideas?
Try {
conn = new connection("dbname=testdb user=postgres");
work Xaction(*conn, "DemoTransaction");
result R = Xaction.exec("SELECT * from items;");
for (result::size_type i=0; i != R.size(); ++I ) {
String itemname = R[i]["itemname"]'
Int quantity, productId;
R[i]["quantity"].to(quantity);
R[i]["productid"].to(productId);
}
} catch(pqxx::sql_error sqlE) {
}
Thanks,
Kevin
_______________________________________________
Libpqxx-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/libpqxx-general
