[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