Incorrect syntax near
HejJeg har følgende kode:
StrSql = "SELECT REPLY_ID, R_MESSAGE FROM FORUM_REPLY WHERE TOPIC_ID = " & TopicID & " ORDER BY REPLY_ID DESC LIMIT 0,1"
Set rsLastPostReply = Server.CreateObject("ADODB.Recordset")
rsLastPostReply.open strSql, my_Conn
Som kommer med denne mystisk fejl (når recordset'et åbnes):
Microsoft OLE DB Provider for SQL Server (0x80040E14)
Line 1: Incorrect syntax near ' '.
Sql-strengen er lig med:
SELECT REPLY_ID, R_MESSAGE FROM FORUM_REPLY WHERE TOPIC_ID = 4765 ORDER BY REPLY_ID DESC LIMIT 0,1
