偶用DW设计ASP程序,用的是DW中ASP模板的型式,当站点和IIS都正确设置后(ASP首页可引被IIS解释出来)就开始在DW中为网页加入数据库(SQL2000),数据库连接正常,测试也正常,浏览也正常!可是当向网页中引入记录集后,IIS就浏览不了了,请问这是为什么,谢谢! 以下是原码内容---------------------------------------------粗体字加入后就不能正确显示了 <%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%> <!--#include file="Connections/Link_MyAccess.asp" --> <% Dim rs_Access__MMColParam rs_Access__MMColParam = "1" If (Request.QueryString("aaa") <> "") Then rs_Access__MMColParam = Request.QueryString("aaa") End If %> <% Dim rs_Access Dim rs_Access_numRows
Set rs_Access = Server.CreateObject("ADODB.Recordset") rs_Access.ActiveConnection = MM_Link_MyAccess_STRING rs_Access.Source = "SELECT * FROM tbl_news WHERE aaa = " + Replace(rs_Access__MMColParam, "'", "''") + " ORDER BY ddd DESC" rs_Access.CursorType = 0 rs_Access.CursorLocation = 2 rs_Access.LockType = 1 rs_Access.Open()
rs_Access_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index
Repeat1__numRows = 5 Repeat1__index = 0 rs_Access_numRows = rs_Access_numRows + Repeat1__numRows %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>无标题文档</title> </head>
<body> <p>这是一个ASP程序 </p> </body> </html> <% rs_Access.Close() Set rs_Access = Nothing %> 以上是原码内容---------------------------------------------粗体字加入后就不能正确显示了