sql.php patches for Oracle.

[Mike Coughlan]

I saw this posting regarding IMP and the fact that one must change all of
the table and field references in horde/lib/Prefs/sql.php to upper case for
Oracle.

I did this as shown below, but it did not work.

/* Build the SQL query. */
        $query = 'SELECT PREF_SCOPE, PREF_NAME, PREF_VALUE FROM ';
        $query .= $this->params['table'] . ' ';
        $query .= 'WHERE PREF_UID = ' . $this->db->quote($this->user);
        $query .= ' AND (PREF_SCOPE = ' . $this->db->quote($this->scope);
        $query .= " OR PREF_SCOPE = 'horde') order by pref_scope";

Can someone please tell me if I need to run some Upper() function on
$this->params['table'] as well?  I do not know PHP and am unsure of the
complete patch.

Thanks for any assistance.

http://marc.theaimsgroup.com/?l=imp&m=100069811326015&w=2