Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Limit rows in MySql 4.1
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... -
Limit rows in MySql 4.1
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... -
sql LIMIT rows in version 4.1
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...- Kris91261
- Thread
- Replies: 2
- Forum: Microsoft SQL Server: Programming
