[dev] Fix for category sql driver for pgsql

Jason M. Felice jfelice at cronosys.com
Wed May 28 15:03:01 PDT 2003


Target column name "key" was single-quoted instead of double-quoted.  I don't
know what database will grok that, but I'm pretty sure the double-quotes are
SQL spec.

-Jay 'Eraserhead' Felice

Index: lib/Category/sql.php
===================================================================
RCS file: /repository/horde/lib/Category/sql.php,v
retrieving revision 1.69
diff -u -u -r1.69 sql.php
--- lib/Category/sql.php	25 May 2003 21:36:54 -0000	1.69
+++ lib/Category/sql.php	28 May 2003 21:50:12 -0000
@@ -582,7 +582,7 @@
     {
         $this->_connect();
 
-        $query = sprintf('SELECT attribute_name as name, attribute_key as \'key\', attribute_value as value FROM horde_category_attributes WHERE category_id = %s',
+        $query = sprintf('SELECT attribute_name as name, attribute_key as "key", attribute_value as value FROM horde_category_attributes WHERE category_id = %s',
                          (int)$cid);
 
         Horde::logMessage('SQL Query by Category_sql::getCategoryAttributes(): ' . $query, __FILE__, __LINE__, LOG_DEBUG);


More information about the dev mailing list