# HG changeset patch
# User Catherine Devlin <catherine.devlin@gmail.com>
# Date 1239202160 14400
# Node ID 1e199ea5b846ebaadb6f1717d8cdebdad185fdaf
# Parent  8d5e4ad05a45e7e4e3fd2af5d41724b7982749d7
fixed single-quote inclusion

diff -r 8d5e4ad05a45 -r 1e199ea5b846 sqlpython/sqlpyPlus.py
--- a/sqlpython/sqlpyPlus.py	Tue Apr 07 15:12:23 2009 -0400
+++ b/sqlpython/sqlpyPlus.py	Wed Apr 08 10:49:20 2009 -0400
@@ -439,11 +439,11 @@
         if datum is None:
             return 'NULL'
         elif isinstance(datum, basestring):
-            return "'%s'" % datum
+            return "'%s'" % datum.replace("'","''")
         try:
             return datum.strftime("TO_DATE('%Y-%m-%d %H:%M:%S', 'YYYY-MM-DD HH24:MI:SS')")
         except AttributeError:
-            return str(datum).replace("'","''")
+            return str(datum)
               
     def output(self, outformat, rowlimit):
         self.tblname = self.tableNameFinder.search(self.querytext).group(1)