ODBC Query with LIMIT

mphare

I am wanting to pull a limited number of records from a database

Does Not Work:

$query = "SELECT RecordingTitle FROM Recordings LIMIT 5,15";
$res = odbc_exec($cs, $query) or die("Query Failed");

If I leave of the LIMIT 5,15, I get all the records in my database. But If I try to LIMIT using the above query statement, I get an error: Syntax error in FROM clause...on line 39 (the odbc_exec() line)

Works:

$query = "SELECT RecordingTitle FROM Recordings";
$res = odbc_exec($cs, $query) or die("Query Failed");

Anybody know of an ODBC limit (no pun intended) in the query statements?

YappyDog

What database are you using?

mphare

Sorry,

MS Access 2000 on a Windows 2000 Pro Box , Apache2 and PHP running as a load module.

BeastRider

This is a problem in databases with no LIMIT statement, like Oracle. The only thing that I know how to do (and that is from samples I've seen on various Oracle "how to" sites) is to create a key field that permits you to test for a >= condition and a < condition to limit the records returned. For example, in your case, you'd create an ascending numeric field and then

$query = "SELECT RecordingTitle FROM Recordings 
                   WHERE 5 <= tablefudgekey < 20";

mphare

Well, THAT stinks 😉

But I appreciate knowing I need to look for a different solution (shame too, I'm no SQL wizard by any stretch, but felt liked I'd found the Holy Grail when I came across LIMIT)

Thanks!

Mike

Doug_G

MS SQL Server supports a TOP which will get you 1/2 way home

"SELECT TOP 10 RecordingTitle FROM Recordings"

TOP is executed after any WHERE, ORDER BY clauses