[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