帮我看一下下面一段asp代码的错误在哪?

来源:百度知道 编辑:UC知道 时间:2024/05/11 12:54:02
我思路是这样的用一行两列的表格,左边显示标题,有相应的超链在右边的单元格显示,如下:

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
dim conn,str
str="driver={sql server};server=.;database=111;uid=sa;pwd=123456;"
set conn=server.CreateObject("adodb.connection")
conn.open str
%>
<%
title=trim(request("title"))
set rs=server.CreateObject("adodb.recordset")
sqlstr="select * from news where title='"&title&"'"
rs.open sqlstr,conn,1,3
do while not rs.eof
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"&g

需要打开两个记录集,否则实现不了你要的效果~!

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
dim conn,str
str="driver={sql server};server=.;database=111;uid=sa;pwd=123456;"
set conn=server.CreateObject("adodb.connection")
conn.open str
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>

<body>
<%
set rs=server.CreateObject("adodb.recordset