[horde] Oracle syntax problem

[Michael Rubinsky]

Quoting Ico Izquierdo <ico at cc.upv.es>:

> Hello,
> I've installed Horde Groupware working with Oracle as database.
> All connections seems work properly but a few ones.
> I think the problem is that some .php don't use MDB2 to build sql  
> sentences, then the syntax are no correct.
> Could you send any help?
> Thanks in advance.
>
> Ico Izquierdo
> ASIC - UPV
>
> Error codes are:
> *---------------------------------------------------------------------------------------------------------------*
> Mar 23 11:15:36 HORDE [error] [kronolith] MDB2 Error: unknown error:  
> _doQuery: [Error message: Could not execute statement]
> [Last executed query: SELECT DISTINCT s.*  FROM kronolith_shares s   
> WHERE (s.perm_guest & 2) != 0 ORDER BY s.attribute_name ASC]

It would appear that Oracle doesn't understand '&' to be a bitwise AND  
operation, instead, needing to use the BITAND function. I don't  
believe MDB2 would be any help here...


Thanks,
mike

--
The Horde Project (www.horde.org)
mrubinsk at horde.org

"Time just hates me. That's why it made me an adult." - Josh Joplin