Re: DB-abstracted database search

On Thu, 14 Feb 2002 08:11:20 -0000, Peter TB Brett wrote: >I'm attempting to add complete database abstraction using PEAR::DB to >an application I'm working on. > >However, as I only have MySQL I'm having problems making sure that my >queries are abstractable. The query I'm especially having problems >with is a query to search the database. If you want to gain full compatibility to database systems different than MySQL, you should always to try to be as close to the SQL standard as possible. Please search the web for the exact definition of this standard. >For instance, is it okay to use 'where table.row like("foo_bar%")'? >Will that work on any SQL server? Is there a PEAR function to >construct database-abstracted searches? No, right now we don't have such system in PEAR. But there are efforts to merge the features of Metabase and PEAR DB, which will provide more abstraction functions to PEAR DB (perhaps it will also include a database-independent way to search datasets). - Martin -- Martin Jansen, <mail@martin-jansen.de> http://www.martin-jansen.de/