Index: trunk/psLib/test/db/verified/tst_psDB.stderr
===================================================================
--- trunk/psLib/test/db/verified/tst_psDB.stderr	(revision 7884)
+++ trunk/psLib/test/db/verified/tst_psDB.stderr	(revision 7978)
@@ -11,6 +11,4 @@
 <DATE><TIME>|<HOST>|I|TPDBInit
     Following should generate error message for NULL database objec
-<DATE><TIME>|<HOST>|E|psDBCleanup (FILE:LINENO)
-    Invalid psDB has been specified.
 
 ---> TESTPOINT PASSED (psDB{dbInit} | tst_psDB.c)
@@ -29,5 +27,5 @@
     Following should generate error message for null database object
 <DATE><TIME>|<HOST>|E|psDBChange (FILE:LINENO)
-    Invalid psDB has been specified.
+    Unallowable operation: dbh is NULL.
 
 ---> TESTPOINT PASSED (psDB{dbChange} | tst_psDB.c)
@@ -39,14 +37,12 @@
 \**********************************************************************************/
 
-<DATE><TIME>|<HOST>|I|TPDBCreateTable
-    Following should generate an error message for NULL parameter
-<DATE><TIME>|<HOST>|E|psDBGenerateCreateTableSQL (FILE:LINENO)
-    Create table parameters may not be NULL.
-<DATE><TIME>|<HOST>|E|psDBCreateTable (FILE:LINENO)
-    Query generation failed.
 <DATE><TIME>|<HOST>|I|TPDBCreateTable
     Following should generate an error message for NULL parameter
 <DATE><TIME>|<HOST>|E|psDBCreateTable (FILE:LINENO)
-    Invalid psDB has been specified.
+    Unallowable operation: md is NULL.
+<DATE><TIME>|<HOST>|I|TPDBCreateTable
+    Following should generate an error message for NULL parameter
+<DATE><TIME>|<HOST>|E|psDBCreateTable (FILE:LINENO)
+    Unallowable operation: dbh is NULL.
 
 ---> TESTPOINT PASSED (psDB{dbCreateTable} | tst_psDB.c)
@@ -60,14 +56,14 @@
 <DATE><TIME>|<HOST>|I|TPDBDropTable
     psDBDropTable: insert should fail here...
-<DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
+<DATE><TIME>|<HOST>|E|p_psDBRunQueryPrepared (FILE:LINENO)
     Failed to prepare query.  Error: Table 'test.table2' doesn't exist
+<DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
+    insert failed
 <DATE><TIME>|<HOST>|E|psDBInsertOneRow (FILE:LINENO)
     Failed to insert row.
 <DATE><TIME>|<HOST>|I|TPDBDropTable
     Following should generate an error message for NULL database object
-<DATE><TIME>|<HOST>|E|p_psDBRunQuery (FILE:LINENO)
-    Invalid psDB has been specified.
 <DATE><TIME>|<HOST>|E|psDBDropTable (FILE:LINENO)
-    Failed to drop table.
+    Unallowable operation: dbh is NULL.
 <DATE><TIME>|<HOST>|I|TPDBDropTable
     Following should generate an error message for invalid table
@@ -78,8 +74,6 @@
 <DATE><TIME>|<HOST>|I|TPDBDropTable
     Following should generate an error message for NULL table
-<DATE><TIME>|<HOST>|E|p_psDBRunQuery (FILE:LINENO)
-    Failed to execute SQL query.  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(null)' at line 1
 <DATE><TIME>|<HOST>|E|psDBDropTable (FILE:LINENO)
-    Failed to drop table.
+    Unallowable operation: tableName is NULL.
 
 ---> TESTPOINT PASSED (psDB{dbDropTable} | tst_psDB.c)
@@ -93,14 +87,10 @@
 <DATE><TIME>|<HOST>|I|TPDBSelectColumn
     Following should generate error message for NULL database
-<DATE><TIME>|<HOST>|E|p_psDBRunQuery (FILE:LINENO)
-    Invalid psDB has been specified.
-<DATE><TIME>|<HOST>|E|psDBSelectColumn (FILE:LINENO)
-    Failed to select column.
+<DATE><TIME>|<HOST>|E|psDBSelectColumn (FILE:LINENO)
+    Unallowable operation: dbh is NULL.
 <DATE><TIME>|<HOST>|I|TPDBSelectColumn
     Following should generate error message for NULL table
-<DATE><TIME>|<HOST>|E|p_psDBRunQuery (FILE:LINENO)
-    Failed to execute SQL query.  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null) LIMIT 10' at line 1
-<DATE><TIME>|<HOST>|E|psDBSelectColumn (FILE:LINENO)
-    Failed to select column.
+<DATE><TIME>|<HOST>|E|psDBSelectColumn (FILE:LINENO)
+    Unallowable operation: tableName is NULL.
 <DATE><TIME>|<HOST>|I|TPDBSelectColumn
     Following should generate error message for invalid table
@@ -126,14 +116,10 @@
 <DATE><TIME>|<HOST>|I|TPDBSelectColumnNum
     Following should generate an error for NULL database object
-<DATE><TIME>|<HOST>|E|p_psDBRunQuery (FILE:LINENO)
-    Invalid psDB has been specified.
-<DATE><TIME>|<HOST>|E|psDBSelectColumn (FILE:LINENO)
-    Failed to select column.
+<DATE><TIME>|<HOST>|E|psDBSelectColumnNum (FILE:LINENO)
+    Unallowable operation: dbh is NULL.
 <DATE><TIME>|<HOST>|I|TPDBSelectColumnNum
     Following should generate an error for NULL table
-<DATE><TIME>|<HOST>|E|p_psDBRunQuery (FILE:LINENO)
-    Failed to execute SQL query.  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null) LIMIT 10' at line 1
-<DATE><TIME>|<HOST>|E|psDBSelectColumn (FILE:LINENO)
-    Failed to select column.
+<DATE><TIME>|<HOST>|E|psDBSelectColumnNum (FILE:LINENO)
+    Unallowable operation: tableName is NULL.
 <DATE><TIME>|<HOST>|I|TPDBSelectColumnNum
     Following should generate an error for invalid column
@@ -163,14 +149,10 @@
 <DATE><TIME>|<HOST>|I|TPDBSelectRows
     Following should generate an error message for NULL database object
-<DATE><TIME>|<HOST>|E|p_psDBRunQuery (FILE:LINENO)
-    Invalid psDB has been specified.
 <DATE><TIME>|<HOST>|E|psDBSelectRows (FILE:LINENO)
-    Query execution failed.
+    Unallowable operation: dbh is NULL.
 <DATE><TIME>|<HOST>|I|TPDBSelectRows
     Following should generate an error message for invalid table
-<DATE><TIME>|<HOST>|E|p_psDBRunQuery (FILE:LINENO)
-    Failed to execute SQL query.  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null) WHERE' at line 1
 <DATE><TIME>|<HOST>|E|psDBSelectRows (FILE:LINENO)
-    Query execution failed.
+    Unallowable operation: tableName is NULL.
 
 ---> TESTPOINT PASSED (psDB{dbSelectRows} | tst_psDB.c)
@@ -184,18 +166,20 @@
 <DATE><TIME>|<HOST>|I|TPDBInsertOneRow
     Following should generate error message for NULL database
-<DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
-    Invalid psDB has been specified.
-<DATE><TIME>|<HOST>|E|psDBInsertOneRow (FILE:LINENO)
-    Failed to insert row.
+<DATE><TIME>|<HOST>|E|psDBInsertOneRow (FILE:LINENO)
+    Unallowable operation: dbh is NULL.
 <DATE><TIME>|<HOST>|I|TPDBInsertOneRow
     Following should generate error message for invalid column item
-<DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
+<DATE><TIME>|<HOST>|E|p_psDBRunQueryPrepared (FILE:LINENO)
     Failed to prepare query.  Error: Unknown column 'key_999' in 'field list'
+<DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
+    insert failed
 <DATE><TIME>|<HOST>|E|psDBInsertOneRow (FILE:LINENO)
     Failed to insert row.
 <DATE><TIME>|<HOST>|I|TPDBInsertOneRow
     Following should generate error message for invalid table
-<DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
+<DATE><TIME>|<HOST>|E|p_psDBRunQueryPrepared (FILE:LINENO)
     Failed to prepare query.  Error: Table 'test.table999' doesn't exist
+<DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
+    insert failed
 <DATE><TIME>|<HOST>|E|psDBInsertOneRow (FILE:LINENO)
     Failed to insert row.
@@ -203,5 +187,5 @@
     Following should generate error message for NULL row
 <DATE><TIME>|<HOST>|E|psDBInsertOneRow (FILE:LINENO)
-    Failed to insert row.
+    Unallowable operation: row is NULL.
 
 ---> TESTPOINT PASSED (psDB{dbInsertOneRow} | tst_psDB.c)
@@ -216,23 +200,25 @@
     Following should generate an error message for NULL database
 <DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
-    Invalid psDB has been specified.
+    Unallowable operation: dbh is NULL.
 <DATE><TIME>|<HOST>|I|TPDBInsertRows
     Following should generate an error message for NULL table
-<DATE><TIME>|<HOST>|E|psDBGenerateInsertRowSQL (FILE:LINENO)
-    Query generation failed.
-<DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
-    Query generation failed.
+<DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
+    Unallowable operation: tableName is NULL.
 <DATE><TIME>|<HOST>|I|TPDBInsertRows
     Following should generate an error message for invalid table
-<DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
+<DATE><TIME>|<HOST>|E|p_psDBRunQueryPrepared (FILE:LINENO)
     Failed to prepare query.  Error: Table 'test.table999' doesn't exist
+<DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
+    insert failed
 <DATE><TIME>|<HOST>|I|TPDBInsertRows
     Following should generate an error message for NULL row array
 <DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
-    Failed to insert row.
+    Unallowable operation: rowSet is NULL.
 <DATE><TIME>|<HOST>|I|TPDBInsertRows
     Following should generate error message for invalid column item
-<DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
+<DATE><TIME>|<HOST>|E|p_psDBRunQueryPrepared (FILE:LINENO)
     Failed to prepare query.  Error: Unknown column 'key_999' in 'field list'
+<DATE><TIME>|<HOST>|E|psDBInsertRows (FILE:LINENO)
+    insert failed
 
 ---> TESTPOINT PASSED (psDB{dbInsertRows} | tst_psDB.c)
@@ -246,14 +232,10 @@
 <DATE><TIME>|<HOST>|I|TPDBDumpRows
     Following should generate error message for NULL database
-<DATE><TIME>|<HOST>|E|p_psDBRunQuery (FILE:LINENO)
-    Invalid psDB has been specified.
-<DATE><TIME>|<HOST>|E|psDBSelectRows (FILE:LINENO)
-    Query execution failed.
+<DATE><TIME>|<HOST>|E|psDBDumpRows (FILE:LINENO)
+    Unallowable operation: dbh is NULL.
 <DATE><TIME>|<HOST>|I|TPDBDumpRows
     Following should generate error message for NULL table
-<DATE><TIME>|<HOST>|E|p_psDBRunQuery (FILE:LINENO)
-    Failed to execute SQL query.  Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'null)' at line 1
-<DATE><TIME>|<HOST>|E|psDBSelectRows (FILE:LINENO)
-    Query execution failed.
+<DATE><TIME>|<HOST>|E|psDBDumpRows (FILE:LINENO)
+    Unallowable operation: tableName is NULL.
 
 ---> TESTPOINT PASSED (psDB{dbDumpRows} | tst_psDB.c)
@@ -268,9 +250,9 @@
     Following should generate an error message for NULL database
 <DATE><TIME>|<HOST>|E|psDBDumpCols (FILE:LINENO)
-    Invalid psDB has been specified.
+    Unallowable operation: dbh is NULL.
 <DATE><TIME>|<HOST>|I|TPDBDumpCols
     Following should generate an error message for NULL table
 <DATE><TIME>|<HOST>|E|psDBDumpCols (FILE:LINENO)
-    NULL table specified.
+    Unallowable operation: tableName is NULL.
 
 ---> TESTPOINT PASSED (psDB{dbDumpCols} | tst_psDB.c)
@@ -285,19 +267,21 @@
     Following should generate an error message for NULL database
 <DATE><TIME>|<HOST>|E|psDBUpdateRows (FILE:LINENO)
-    Invalid psDB has been specified.
+    Unallowable operation: dbh is NULL.
 <DATE><TIME>|<HOST>|I|TPDBUpdateRows
     Following should generate an error message for invalid table
+<DATE><TIME>|<HOST>|E|p_psDBRunQueryPrepared (FILE:LINENO)
+    Failed to prepare query.  Error: Table 'test.table999' doesn't exist
 <DATE><TIME>|<HOST>|E|psDBUpdateRows (FILE:LINENO)
-    Failed to prepare query.  Error: Table 'test.table999' doesn't exist
+    update failed
 <DATE><TIME>|<HOST>|I|TPDBUpdateRows
     Following should generate an error message for NULL updates
-<DATE><TIME>|<HOST>|E|psDBGenerateUpdateRowSQL (FILE:LINENO)
-    Update row SQL generate fail: values and where params may not be NULL.
 <DATE><TIME>|<HOST>|E|psDBUpdateRows (FILE:LINENO)
-    Query generation failed.
+    Unallowable operation: values is NULL.
 <DATE><TIME>|<HOST>|I|TPDBUpdateRows
     Following should generate an error message for invalid where
+<DATE><TIME>|<HOST>|E|p_psDBRunQueryPrepared (FILE:LINENO)
+    Failed to prepare query.  Error: Unknown column 'col999' in 'where clause'
 <DATE><TIME>|<HOST>|E|psDBUpdateRows (FILE:LINENO)
-    Failed to prepare query.  Error: Unknown column 'col999' in 'where clause'
+    update failed
 
 ---> TESTPOINT PASSED (psDB{dbUpdateRows} | tst_psDB.c)
@@ -312,5 +296,5 @@
     Following should generate error message for NULL database
 <DATE><TIME>|<HOST>|E|psDBDeleteRows (FILE:LINENO)
-    Invalid psDB has been specified.
+    Unallowable operation: dbh is NULL.
 <DATE><TIME>|<HOST>|I|TPDBDeleteRows
     Following should generate error message for invalid table