如何在外国免费ASP空间正确显示数据库信息
这里有网址,可以看一下错误效果http://www27.brinkster.com/mandyk
下面是简单显示数据库的ASP程序,高手们请告诉哪错了,为何有上面网址所说的错误:
<%@language=vbscript%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>New Page 1</title>
</head>
<body>
返回测试主页3
<%
set conn=server.createobject("adodb.connection")
ad="provider=microsoft.jet.oledb.4.0;data source="&server.MapPath("1.mdb")
conn.open ad&";jet oledb:database password=ssfukga"
set rs=server.CreateObject("adodb.recordset")
sql="SELECT * FROM aa"
rs.open sql,conn,1,3
for i=1 to 10
if rs.eof=false then
%>
<table border="1" cellpadding="0" width="100%">
<tr>
<td width="100%">读取:<%=rs.fields("name")%></td>
</tr>
<% rs.movenext
else
exit for
end if
next
rs.close%>
</table>
</body>
</html>