在使用DW新建一个记录集时,提示FROM子句语法错误,
可是看代码时似乎没有错啊,请问这是怎么回事,该怎么解决呢?
代码如下:
1
2Dim Recordset1
3Dim Recordset1_numRows
4
5Set Recordset1 = Server.CreateObject("ADODB.Recordset")
6Recordset1.ActiveConnection = MM_Conn_STRING
7Recordset1.Source = "SELECT Password, UserName FROM User"
8Recordset1.CursorType = 0
9Recordset1.CursorLocation = 2
10Recordset1.LockType = 1
11Recordset1.Open()
12
13Recordset1_numRows = 0
---------------------------------------------------------------
SELECT Password, UserName FROM [User]
user 是数据库的关键字
---------------------------------------------------------------
user是关键字!!!
---------------------------------------------------------------
user是关键字!!!
date也是。name.