Re: DB_Dataobjects::find() and Postgres 7.3 problem

the last release uses a pear db call to generate this for postgres - make sure you updated pear db and dataobjects i'm using postgres here alot with it so it does work ;) Regards alan Hans Westerbeek wrote:

Hi, As of version 7.3, PostgreSQL requires that the LIMIT clause is used like this: SELECT * FROM headlines LIMIT 10 OFFSET 0; (returning the first 10 records in the table) DB_Dataobjects still uses LIMIT 0, 10, therefore this piece of code fails:

$do =& $this->_getDaObject();       $do->limit(0, 10);

$do->orderBy('id DESC'); $do->find(); I can see how this can be fixed in the limit() method but i'm not sure if that's the right way to go... Hans

-- Can you help out? Need Consulting Services or Know of a Job? http://www.akbkhome.com