求教遍历数据库遇到的问题!本来想统计用户的数量!
tavor 2003-07-12 02:09:17 代码如下:
<%
dim udb
udb="myweb.mdb"
Set Conn = Server.CreateObject("ADODB.Connection")
myconn="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(""&udb&"")
Conn.Open MyConn
usercount=0
SET rs=Server.CreateObject("ADODB.Recordset")
sql="SELECT * FROM user"
rs.OPEN sql, Conn,1,1
DO while NOT rs.eof
usercount=usercount+1
if rs.eof then
Exit do
end if
loop
response.Write(usercount)
rs.close
set rs=nothing
Conn.close
set Conn=nothing
%>
浏览器提示如下:
错误类型:
Microsoft JET Database Engine (0x80040E14)
FROM 子句语法错误。
/myweb/count.asp, 第 10 行