PEAR::DB compatible for mysql 3.23 ?
| From: | Demian Turner | Date: | Thu, 17 Mar 2005 16:50:07 +0000 |
| Subject: | PEAR::DB compatible for mysql 3.23 ? | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-18118@lists.php.net to get a copy of this message | ||
Hiya Daniel
I've read (I think) most of your recent portability articles on PEAR::DB but i think i've come across an issue that's not documented.
when you call getOne(), eg:
$result = $this->getOne("SELECT GET_LOCK('sequence_lock',10)")
the SQL generated uses a limit syntax (I think) not supported by mysql 3.23:
SELECT GET_LOCK('sequence_lock',10) LIMIT 0, 1
is there a portability setting to get around this?
cheers
Demian