Limit rows in MySql 4.1

[Kris91261]

I've used the LIMIT function in mySql 5.0 with no problem. Such as:
sql = "select * from Events order by EventDate DESC, 'LIMIT 0,3'"

I have tried to use the same query on a mySql 4.1.22 server and I don't get an error but it doesn't adhere to the LIMIT part of the query.

Any ideas on a way to pull four rows from a table without the LIMIT function? I want the four most recent entries in the table.

I would appreciate any help you could give.

Thanks,
Kris91261

 

[r937]

ORDER BY EventDate DESC LIMIT 4

no comma after DESC, no quotes around LIMIT



r937.com | rudy.ca

 

[Kris91261]

r937,

I should have mentioned that this sql statement is in the context of ASP. Without the single quotes it fails completely. I have used the LIMIT parameter on a server that was running MySql 5.0 and had no problem. Version 4.1 does not fail with the statement but it ignores the LIMIT parameter. Do you know of any other ways to extract the last 4 records in a table? Thanks for you help.

Kris91261

 

[r937]

try running your queries outside of ASP and you will see that the single quotes are not allowed, and the LIMIT does work

r937.com | rudy.ca