ASP - 1064 [TCX][MyODBC]You have an error in your SQL syntax
Error Type:ADODB.Recordset.1 (0x80004005)
SQLState: 4 Native Error Code: 1064 [TCX][MyODBC]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 '' at line 1
/forum.asp, line 20
forum.asp:
<!--#include file="inc/top.asp"-->
<%
strId_rs = request("id")
if strId_rs <> "" Then
strId_rs = checkid(strId_rs)
else
strId_rs = checkid(0)
End If
' Vis id er valgt
If (strId_rs <> "" and strId_rs <> 0) and grouptread(strId_rs) = 0 Then
' line 13
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open strDatabase
strIdList = "Første ukendt"
' line 19
strSQL = "Select * from Forum where Forum = " & id
Set rs = Conn.Execute(strSQL)
If not rs.eof Then
strIdCheck = 1
Do
strIdList = strIdList & "," & rs("Id")
rs.MoveNext
Loop While Not rs.EOF
End If
Conn.Close
Set Conn = Nothing
mySQL:
http://www.googus.dk/mysql.jpg

