SQL kald - virker i Access hvorfor ikke i MySQL
set rs_forside = Server.CreateObject("ADODB.RecordSet")rs_forside.open "SELECT TOP 2 * FROM forside WHERE aktiv = 1 ORDER BY id DESC", Conn_sites
Virker af en eller anden grund ikke:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.23-standard-log]You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '2 * FROM forside WHERE aktiv = 1 ORDER BY id DESC' at line 1
/indhold2/default.asp, line 12
Men hvis jeg fjerner "top 2" virker det fint - hvorfor?
