[Microsoft][ODBC Microsoft Access Driver] FROM 子句语法错误。
SELECT*FROMuser-infor<%DimRecordset1DimRecordset1_cmdDimRecordset1_numRowsSetRecordse...
SELECT *
FROM user-infor
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows
Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_yu_STRING
Recordset1_cmd.CommandText = "SELECT * FROM user-infor"
Recordset1_cmd.Prepared = true
Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
用Dreamwe做asp网页，连接数据库 展开
FROM user-infor
<%
Dim Recordset1
Dim Recordset1_cmd
Dim Recordset1_numRows
Set Recordset1_cmd = Server.CreateObject ("ADODB.Command")
Recordset1_cmd.ActiveConnection = MM_yu_STRING
Recordset1_cmd.CommandText = "SELECT * FROM user-infor"
Recordset1_cmd.Prepared = true
Set Recordset1 = Recordset1_cmd.Execute
Recordset1_numRows = 0
%>
用Dreamwe做asp网页，连接数据库 展开
展开全部
user-infor
Sql语句不能使用减号
应该改成user_infor，如果数据库名称也包含减号，改为下划线
Sql语句不能使用减号
应该改成user_infor，如果数据库名称也包含减号，改为下划线
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
