[dev] vfs problems with mysql....

Amith Varghese amith@xalan.com
Sat Oct 26 17:52:17 2002


I'm trying to delete a folder using the VFS driver in an app I'm trying to 
write.  But for some reason the folder will not delete correctly.  I've traced 
it to this code.

$result = $this->_db->query(sprintf('DELETE FROM %s WHERE vfs_type = %s
AND vfs_path %s AND vfs_name = %s',
                                            $this->_params['table'],
                                            $this->_db->quote(HORDE_VFS_FOLDER),
                                            (empty($path) && $this->_db->dbsynta
x = 'oci8') ? ' IS NULL' : ' = ' . $this->_db->quote($path),
                                            $this->_db->quote($name)));

and the problem I am having is that $this->_db->dbsyntax = 'oci8' is returning 
oci8 when I am using MySQL. So the query is using IS NULL instead of ''  
Strange.  Does anyone have any ideas why this is happening?  I don't even have 
Oracle compiled into PHP.

My DB definition is as follows

$backends['sql'] = array(
    'name' => 'SQL Server',
    'driver' => 'sql',
    'preferred' => '',
    'params' => array('phptype' => 'mysql',
                      'hostspec' => 'localhost',
                      'database' => 'horde',
                      'username' => 'horde',
                      'password' => '*****',
                      'table' => 'horde_vfs'));


Thanks
Amith