I am trying to conduct the following select statement in an ASP page:
select * from table
order by column1 desc
limit 10
In Query Editor the query successfully returns the first 10 rows of the table, however when I view the ASP page I get the following error:
Database Results Error
Description: [TCX][MyODBC]You have an error in your SQL syntax near 'limit 256' at line 1
Number: -2147217911 (0x80040E09)
Source: Microsoft OLE DB Provider for ODBC Drivers
I am using IIS, Front Page 2000, and mySQL 3.23.28. Any recommendations?
select * from table
order by column1 desc
limit 10
In Query Editor the query successfully returns the first 10 rows of the table, however when I view the ASP page I get the following error:
Database Results Error
Description: [TCX][MyODBC]You have an error in your SQL syntax near 'limit 256' at line 1
Number: -2147217911 (0x80040E09)
Source: Microsoft OLE DB Provider for ODBC Drivers
I am using IIS, Front Page 2000, and mySQL 3.23.28. Any recommendations?