right syntax?
Dette:<%
strSQL = "SELECT TOP 1 * FROM befrontnews ORDER BY infoID DESC"
Set RS = Conn.Execute (strSQL)
%>
- udløser denne fejl:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-4.0.18-nt]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 '1 * FROM befrontnews ORDER BY infoID DESC' at line 1
/default.asp, line 54
Linie 54: Set RS = Conn.Execute (strSQL)
Hvad skyldes det? Håber på hurtig hjælp :/
