db_bridge/postgresql_db.cpp
changeset 15 5a0ca1f9a2f1
parent 14 862d63715611
child 17 b3731a25b9ec
--- a/db_bridge/postgresql_db.cpp
+++ b/db_bridge/postgresql_db.cpp
@@ -4,6 +4,7 @@
  */
 
 #include <postgresql_db.h>
+#include <exception>
 
 PostgreSQL_DB::PostgreSQL_DB (std::string srv, std::string usr, std::string pwd, std::string db)
 {
@@ -43,7 +44,8 @@
     Abstract_DB::DB_ROW vec;
     Abstract_DB::DB_RESULT rows;
     PGresult *res;
-    int i, j, nFields;
+    int i, j;
+    int nFields, nRows;
 
     /*
      * send SQL query
@@ -51,13 +53,14 @@
     res = PQexec (conn, sql_string.c_str ());
 
     nFields = PQnfields (res);
+    nRows = PQntuples (res);
 
-    std::cout << "Die Abfrage ergab " << nFields << " Zeilen." << std::endl;
+    std::cout << "Die Abfrage hat " << nFields << " Spalte(n) und " << nRows << " Reihe(n)." << std::endl;
 
     /*
      * push everything into a vector< vector<string> >
      */
-    for (i = 0; i < PQntuples (res); i++) {
+    for (i = 0; i < nRows; i++) {
         for (j = 0; j < nFields; j++) {
             vec.push_back (PQgetvalue (res, i, j));
         }