Almond wrote:

> I try to port the Owl (http://owl.sourceforge.net) knowledge base
> using firebird and nearly succeed.
>
> It use phplib for DB access. The tables contain the reserve word
> "password" as column name. I currently alter the source and quote all
> the 'password' field. For compatibility, is it better change the
> phplib db module, i.e. check 'password' in query, then quote it, so
> the source is same as the distribution.
>
> I saw some package have this problem. Please advise if there is any
> better method.
>
> Any comment is welcome.

The BEST solution is to rename the field. A few projects I have been involved
with are quite amenable to that 'tidy up' as it also allows porting to other
databases as well. I had thought password was reserved in oracle as well.

Failing that, something in your 'db_firebird.php' module to add the quotes is
second best.

--
Lester Caine - G8HFL
-----------------------------
Contact - http://home.lsces.co.uk/lsces/wiki/?page=contact
L.S.Caine Electronic Services - http://home.lsces.co.uk
MEDW - http://home.lsces.co.uk/ModelEngineersDigitalWorkshop/
Firebird - http://www.firebirdsql.org/index.php