# HG changeset patch
# User Catherine Devlin <catherine.devlin@gmail.com>
# Date 1239131543 14400
# Node ID 8d5e4ad05a45e7e4e3fd2af5d41724b7982749d7
# Parent  a6cbcf24f1485a29fbd15f16caae0fed99530299
pursuing errors in \i when apostrophes in strings

diff -r a6cbcf24f148 -r 8d5e4ad05a45 sqlpython/sqlpyPlus.py
--- a/sqlpython/sqlpyPlus.py	Tue Apr 07 13:15:07 2009 -0400
+++ b/sqlpython/sqlpyPlus.py	Tue Apr 07 15:12:23 2009 -0400
@@ -443,7 +443,7 @@
         try:
             return datum.strftime("TO_DATE('%Y-%m-%d %H:%M:%S', 'YYYY-MM-DD HH24:MI:SS')")
         except AttributeError:
-            return str(datum)
+            return str(datum).replace("'","''")
               
     def output(self, outformat, rowlimit):
         self.tblname = self.tableNameFinder.search(self.querytext).group(1)