急:我在用ConnectObject.Execute执行查询的时候出现提示FROM子句出错,详细如下。
如下代码:
<%
Dim conn, rst, sSQL
Set conn = Server.CreateObject("ADODB.Connection")
Set rst = Server.CreateObject("ADODB.Recordset")
conn.ConnectionString = "PROVIDER=SQLOLEDB;DATA SOURCE=" & _
Server.Mappath("data/storage.mdb")
conn.Open
sSQL = "SELECT username, password, right "
sSQL = sSQL & "FROM user WHERE username = 'admin'"
Set rst = conn.Execute(sSQL,,adCmdText) '执行到这条语句的时候提示出错:"FROM子句语法错误。"
%>
哪位大哥知道这是怎么回事,望指点一二,小弟不胜感激。