Question

求救:[Microsoft][ODBC Microsoft Access Driver] FROM 子句语法错误

<%
Dim rs
Dim conn
public strsno
strsno = Request.QueryString("sno")
sub Get_Record()
Set rs = Nothing
Set conn = Nothing

Set conn=Server.CreateObject("ADODB.Connection")
strConn="Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.mappath("user.mdb")
conn.Open strConn
strsql="select * from course"
strsql=strsql & "where sno=" & trim(strno)
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open strsql,strConn,,,adCmdText
End sub
错误在倒数第五行，表名没有拼错，实在看不出是哪里出错．

Answer 1

少了个空格：
strsql="select * from course"
strsql=strsql & " where sno=" & trim(strno)

Answer 2

你问我，我就告诉你！但是我也不知道该怎么告诉你