[imp] mysql->quote problem with IMP and Turba

[Alexander Skwar]

Zitat von Jeff Tucker <jefft@wciatl.com>:

> --On Tuesday, October 09, 2001 6:17 PM -0400 Jeff Tucker
> <jefft@wciatl.com> 
> wrote:
> 
> >
> > What I found was that IMP was not generating valid MySQL
> requests.
> > Specifically, the strings were not being quoted correctly.
> Strings
> > weren't getting any quotes at all. In my log, I get entries like:
> >
> 
> OK, answering my own question here.
> 
> In the file horde/lib/Prefs/sql.php, I find the representative
> code:


You seem to have an old version of lib/Prefs/sql.php.  This is line 144
to 182 in my file:

        /* 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";


Alexander Skwar
-- 
How to quote:  http://learn.to/quote (de) http://quote.6x.to (en)
Homepage:      http://www.digitalprojects.com | http://www.iso-top.de
   iso-top.de - Die günstige Art an Linux Distributionen zu kommen

-------------------------------------------------
This mail sent through IMP: http://horde.org/imp/