This is an archived copy of the forum for reference purposes

translatedQuery - limit

posted by darren 9 years ago

Hi Guys,

Not sure if bug or im doing something wrong...

Im connecting to an Oracle DB

$db->translatedQuery("SQL LIMIT 10,20"); < FAILS

$db->translatedQuery("SQL LIMIT 10"); < WORKS

Its probably me :(

Any ideas would be appreciated...

I believe the problem is the syntax you are using. Instead of using the MySQL-specific LIMIT 10,10, you should use the more compatible format LIMIT 10 OFFSET 10.

SELECT * FROM users LIMIT 10 OFFSET 10

posted by wbond 9 years ago