高考问答飞虎二粤语:asp问题 在线急等
来源：百度文库 编辑：高考问答 时间：2024/04/29 10:36:48
<%
dim conn
dim connstr
dim db
dim sqls
db="file/mydb.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
response.write "<table>"
conn.Open connstr
Set conn = Server.CreateObject("ADODB.recordset")
response.write "数据库连接成功"
<% sqls="select * from article where Nclassid=1 order by dateandtime desc"
set rs=conn.Execute(sqls,recordsAffected,adcmdtext)
for i=0 to 5 %>
<tr>
<td><a href="article/list.asp?id=<%=rs("articleid")%>"><%=rs
("title")%></a>(<font color="#FF0000"><%=rs("dateandtime")%></font>)<img src="image/new.gif"
></td>
</tr>
<%rs.movenext
if rs.eof then exit for
next
response.write "</table>"
%>
Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp，行242
Microsoft VBScript 编译器错误 错误 '800a0400'
缺少语句
/eb20041/2-7/conn1.asp，行14
<% sqls="select * from article where Nclassid=1 order by dateandtime desc"
^
<% 符号没有成对匹配
去掉这一行的<%符号 或者在
response.write "数据库连接成功"
这一行后面加上 %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<head>
<title></title>
<meta name="GENERATOR" content="Microsoft Visual Studio .NET 7.1">
<meta name=ProgId content=VisualStudio.HTML>
<meta name=Originator content="Microsoft Visual Studio .NET 7.1">
</head>
<body>
<%
dim conn
dim connstr
dim db
dim sqls
db="file/mydb.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
response.write "<table>"
conn.Open connstr
Set conn = Server.CreateObject("ADODB.recordset")
response.write "数据库连接成功"
sqls="select * from article where Nclassid=1 order by dateandtime desc"
set rs=conn.Execute(sqls,recordsAffected,adcmdtext)
for i=0 to 5
%>
<tr>
<td><a href="article/list.asp?id=<%=rs("articleid")%>"><%=rs ("title")%></a>
<font color="#FF0000"><%=rs("dateandtime")%></font>
<img src="image/new.gif" >
</td>
</tr>
<%rs.movenext
if rs.eof then exit for
next
response.write "</table>"
%>
</body>
</html>
我这我调试了的,你试一下应该没有错了