Adding numaffectedrows() and insertid() into the SQL class. Also having

a slightly better error support. Need more work on that though.

1 files changed, 14 insertions, 0 deletions

diff --git a/lib/SQL.cc b/lib/SQL.cc
index 26620e4..e599f95 100644
--- a/lib/SQL.cc
+++ b/lib/SQL.cc
@@ -34,6 +34,8 @@ void SQLConnection::query(String q) throw(GeneralException) {
 	mysql_free_result(res);
     }
 
+    res = 0;
+
     if (mysql_real_query(&con, ((ugly_string)q).p, q.strlen())) {
 	throw GeneralException(String("Couldn't run query ") + q);
     }
@@ -44,10 +46,14 @@ void SQLConnection::query(String q) throw(GeneralException) {
 	nr = mysql_num_rows(res);
 	nf = mysql_num_fields(res);
 	fields = mysql_fetch_fields(res);
+        na = mysql_affected_rows(res);
+        ii = mysql_insert_id(res);
     } else {
 	nr = 0;
 	nf = 0;
 	fields = 0;
+        na = 0;
+        ii = -1;
     }
 }
 
@@ -73,4 +79,12 @@ AssocArray SQLConnection::fetchrow() {
     return r;
 }
 
+int SQLConnection::numaffectedrows() {
+    return na;
+}
+
+int SQLConnection::insertid() {
+    return ii;
+}
+
 #endif