PHP Pear - PEAR::DB compatible for mysql 3.23 ?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

PEAR::DB compatible for mysql 3.23 ?

Demian Turner

2005-03-17, 3:58 pm

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

Sponsored Links