使用DW新建记录集时遇到一个问题?

在使用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.

Published At
Categories with Web编程
Tagged with
comments powered by Disqus