changeset 332:8d5e4ad05a45

pursuing errors in \i when apostrophes in strings
author Catherine Devlin <catherine.devlin@gmail.com>
date Tue, 07 Apr 2009 15:12:23 -0400
parents a6cbcf24f148
children 1cde0ec62e61 1e199ea5b846
files sqlpython/sqlpyPlus.py
diffstat 1 files changed, 1 insertions(+), 1 deletions(-) [+]
line wrap: on
line diff
--- 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)