Question

SQL server"user"附近有语法错误

<%
Dim Recordset1
Dim Recordset1_numRows
Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_connuser_STRING
Recordset1.Source = "SELECT username, Question FROM user WHERE username = '" + Replace(Recordset1__MMColParam, "'", "''") + "'"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()
Recordset1_numRows = 0
%>
这段哪儿错了，dreamweaver自动生成的代码有错

Answer 1

sqlserver中user是个关键字，不能直接引用，尝试在user两边加上中括号，如下

Recordset1.Source = "SELECT username, Question FROM [user] WHERE username = '" + Replace(Recordset1__MMColParam, "'", "''") + "'"

Answer 2

user在SQL中是关键字，建议两边加上双引号表示字符串变量

Answer 3

你把中间那个sql语句放在sqlserver里面跑一下，我没有你这种表，不知道那里有错