LIMIT clause with Access

[bitwise]

I'm having a problem using the LIMIT clause for a select statement. I want to limit the number of rows selected in my query to a range, of some many per page, so I planned on using LIMIT startingpoint,numberofrows. For some reason I get this error:

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression 'loginname limit 10'., SQL state 37000 in SQLExecDirect

Is my syntax wrong, or do I need to find out some other method of acomplishing this? I'd like to avoid querying the entire table, and using PHP to filter it, I'd rather just limit it with the query itself. Any idea what my problem is? Here is the query that produced the above results.

SELECT * FROM Customers ORDER BY LoginName LIMIT 10

Miles
[e-mail]

[Anon]

Instead of:

SELECT * FROM Customers ORDER BY LoginName LIMIT 10

Use:

SELECT TOP 10 * FROM Customers ORDER BY LoginName

[Anon]

actually i wanted a range, not just the top. I got it now.

thanks

Miles

[Anon]

I have the same problem ... how did you manage to get a range ???

Max

[bitwise]

Well it appears there isn't any way to do this with Access, because there doesn't seem to be anything comparable to LIMIT.

So what I ended up doing was using TOP to get the smallest set of data I could, that still including all the records I needed.

Example: I need rows 15-25 out of 30 rows of data

SELECT TOP 25 * FROM table ORDER BY name
would be the query.

then i looped until i got to the record i needed.

          [$startrec is 15]

for($i = 0; $i < $startrec; $i++) {
odbc_fetch_row($result);
}

Now you're on row 15, and you can output it and fetch another row and keep going until your out of data.

I hope this was helpful to you.

Miles Mawyer
[e-mail]

[Anon]

Now that's my problem.

I also try to use the LIMIT clause with Access in order to devide my forum messages into pages but it seems not to be working 🙂

This is my query:

"...WHERE ForumId = 1 AND ReplyTo = 0 LIMIT 0, 10"

Is there any way I can use LIMIT's fanctionality in Access?

[Anon]

Does anyone have a solution to this problem? Seperating Access Query results into pages, that is?

[Anon]

nope....i'm in the same boat...and it's kinda frustrating.

any insight would be greatly appreciated.

Thanks in advance.