Index: trunk/psLib/src/db/psDB.c
===================================================================
--- trunk/psLib/src/db/psDB.c	(revision 4429)
+++ trunk/psLib/src/db/psDB.c	(revision 4430)
@@ -12,6 +12,6 @@
  *  @author Joshua Hoblitt
  *
- *  @version $Revision: 1.36 $ $Name: not supported by cvs2svn $
- *  @date $Date: 2005-06-29 19:40:23 $
+ *  @version $Revision: 1.37 $ $Name: not supported by cvs2svn $
+ *  @date $Date: 2005-06-29 20:33:37 $
  *
  *  Copyright 2005 Joshua Hoblitt, University of Hawaii
@@ -768,8 +768,9 @@
     psFree(bind);
 
+    // mysql_stmt_affected_rows() must be called before a commit
+    rowsAffected = mysql_stmt_affected_rows(stmt);
+
     // point of no return
     mysql_commit(dbh->mysql);
-
-    rowsAffected = mysql_stmt_affected_rows(stmt);
 
     mysql_stmt_close(stmt);