'db->quote' not working
   
    emilio@freedom2surf.net
     
    emilio@freedom2surf.net
       
    Tue, 18 Sep 2001 12:25:47 +0000
    
    
  
Running latest cvs of horde/imp (18th sept.)
I am having problems with the sql.php file. (/horde/lib/Prefs/sql.php). 
using "db->quote" doesn't seem to be working, however when I change the code 
(see below), it all works fine. Any suggestions?
(I have had to change all code respectively)
Example of Original code
/* 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";
Example of hacked code
/* Build the SQL query. */
        $query = 'select pref_scope, pref_name, pref_value from ';
        $query .= $this->params['table'] . ' ';
        $query .= 'where pref_uid = \'' . $this->user .'\'';
        $query .= ' and (pref_scope = \'' . $this->scope . '\'';
        $query .= " or pref_scope = 'horde') order by pref_scope";
Paste of test.php
Horde Versions
Horde: 1.3.5-cvs 
IMP: 2.3.7-cvs 
Turba: 0.0.3-cvs 
PHP Version
View phpinfo() screen 
PHP Version: 4.0.6 
PHP Major Version: 4.0 
PHP Minor Version: 6 
PHP Version Classification: release 
You are running a supported version of PHP.
PHP Module Capabilities
FTP Support: No 
Gettext Support: Yes 
IMAP Support: Yes 
LDAP Support: No 
MCAL Support: No 
Mcrypt Support: Yes 
MySQL Support: Yes 
PostgreSQL Support: Yes 
XML Support: Yes 
Miscellaneous PHP Settings
magic_quotes_runtime set to Off: Yes 
PHP Sessions
Session counter: 1 
To unregister the session: click here 
PEAR
PEAR - Yes 
Mail::RFC822 - Yes 
Log - Yes 
DB - Yes 
Thanks in advanced,
Emilio
------------------------------------------------- 
Everyone should have http://www.freedom2surf.net/