gnue/gnuef/src/drivers/postgresql DBdriver.py

[James Thompson]

CVSROOT:        /cvs
Module name:    gnue
Changes by:     James Thompson <address@hidden> 01/03/06 19:02:24

Modified files:
        gnuef/src/drivers/postgresql: DBdriver.py 

Log message:
        Fix to allow postgresql queries to contain a '

CVSWeb URLs:
http://subversions.gnu.org/cgi-bin/cvsweb/gnue/gnuef/src/drivers/postgresql/DBdriver.py.diff?r1=1.13&r2=1.14

Patches:
Index: gnue/gnuef/src/drivers/postgresql/DBdriver.py
diff -u gnue/gnuef/src/drivers/postgresql/DBdriver.py:1.13 
gnue/gnuef/src/drivers/postgresql/DBdriver.py:1.14
--- gnue/gnuef/src/drivers/postgresql/DBdriver.py:1.13  Mon Feb 19 09:31:08 2001
+++ gnue/gnuef/src/drivers/postgresql/DBdriver.py       Tue Mar  6 19:02:23 2001
@@ -121,10 +121,11 @@
         fields = " oid AS oid_%s, %s " % (table, string.join(mask.keys(), ','))
         for fieldname in mask.keys():
           if mask[fieldname] != None and len(mask[fieldname]):
+            value = string.replace(mask[fieldname],"'","''")
             if qualifier == None:
-              qualifier = "WHERE %s LIKE  '%s'" % (fieldname,mask[fieldname])
+              qualifier = "WHERE %s LIKE  '%s'" % (fieldname,value)
             else:
-              qualifier = "%s AND %s LIKE  '%s'" % (qualifier, 
fieldname,mask[fieldname])
+              qualifier = "%s AND %s LIKE  '%s'" % (qualifier, fieldname,value)
       
       sql = action + fields + location + (qualifier and qualifier or "")
       if order_by != None: