| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 620 人关注过本帖
标题:大虾,这种问题解决得了吗!!??
只看楼主 加入收藏
whg8208
Rank: 1
等 级:新手上路
帖 子:4
专家分:0
注 册:2005-3-16
收藏
 问题点数:0 回复次数:8 
大虾,这种问题解决得了吗!!??

在这段代码里,有我插入的服务器类型,而正是在我插入了类型之后,就不能预览了,用IIS解析过也不行,大虾们能不能帮我一把!!是什么原因啊!!??? <!--#include file="../Connections/conn.asp" --> <% Dim rs Dim rs_numRows

Set rs = Server.CreateObject("ADODB.Recordset") rs.ActiveConnection = MM_conn_STRING rs.Source = "SELECT * FROM bbs ORDER BY addTime DESC" rs.CursorType = 0 rs.CursorLocation = 2 rs.LockType = 1 rs.Open()

rs_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index

Repeat1__numRows = 15 Repeat1__index = 0 rs_numRows = rs_numRows + Repeat1__numRows %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables

Dim rs_total Dim rs_first Dim rs_last

' set the record count rs_total = rs.RecordCount

' set the number of rows displayed on this page If (rs_numRows < 0) Then rs_numRows = rs_total Elseif (rs_numRows = 0) Then rs_numRows = 1 End If

' set the first and last displayed record rs_first = 1 rs_last = rs_first + rs_numRows - 1

' if we have the correct record count, check the other stats If (rs_total <> -1) Then If (rs_first > rs_total) Then rs_first = rs_total End If If (rs_last > rs_total) Then rs_last = rs_total End If If (rs_numRows > rs_total) Then rs_numRows = rs_total End If End If %> <% Dim MM_paramName %> <% ' *** Move To Record and Go To Record: declare variables

Dim MM_rs Dim MM_rsCount Dim MM_size Dim MM_uniqueCol Dim MM_offset Dim MM_atTotal Dim MM_paramIsDefined

Dim MM_param Dim MM_index

Set MM_rs = rs MM_rsCount = rs_total MM_size = rs_numRows MM_uniqueCol = "" MM_paramName = "" MM_offset = 0 MM_atTotal = false MM_paramIsDefined = false If (MM_paramName <> "") Then MM_paramIsDefined = (Request.QueryString(MM_paramName) <> "") End If %> <% ' *** Move To Record: handle 'index' or 'offset' parameter

if (Not MM_paramIsDefined And MM_rsCount <> 0) then

' use index parameter if defined, otherwise use offset parameter MM_param = Request.QueryString("index") If (MM_param = "") Then MM_param = Request.QueryString("offset") End If If (MM_param <> "") Then MM_offset = Int(MM_param) End If

' if we have a record count, check if we are past the end of the recordset If (MM_rsCount <> -1) Then If (MM_offset >= MM_rsCount Or MM_offset = -1) Then ' past end or move last If ((MM_rsCount Mod MM_size) > 0) Then ' last page not a full repeat region MM_offset = MM_rsCount - (MM_rsCount Mod MM_size) Else MM_offset = MM_rsCount - MM_size End If End If End If

' move the cursor to the selected record MM_index = 0 While ((Not MM_rs.EOF) And (MM_index < MM_offset Or MM_offset = -1)) MM_rs.MoveNext MM_index = MM_index + 1 Wend If (MM_rs.EOF) Then MM_offset = MM_index ' set MM_offset to the last possible record End If

End If %> <% ' *** Move To Record: if we dont know the record count, check the display range

If (MM_rsCount = -1) Then

' walk to the end of the display range for this page MM_index = MM_offset While (Not MM_rs.EOF And (MM_size < 0 Or MM_index < MM_offset + MM_size)) MM_rs.MoveNext MM_index = MM_index + 1 Wend

' if we walked off the end of the recordset, set MM_rsCount and MM_size If (MM_rs.EOF) Then MM_rsCount = MM_index If (MM_size < 0 Or MM_size > MM_rsCount) Then MM_size = MM_rsCount End If End If

' if we walked off the end, set the offset based on page size If (MM_rs.EOF And Not MM_paramIsDefined) Then If (MM_offset > MM_rsCount - MM_size Or MM_offset = -1) Then If ((MM_rsCount Mod MM_size) > 0) Then MM_offset = MM_rsCount - (MM_rsCount Mod MM_size) Else MM_offset = MM_rsCount - MM_size End If End If End If

' reset the cursor to the beginning If (MM_rs.CursorType > 0) Then MM_rs.MoveFirst Else MM_rs.Requery End If

' move the cursor to the selected record MM_index = 0 While (Not MM_rs.EOF And MM_index < MM_offset) MM_rs.MoveNext MM_index = MM_index + 1 Wend End If %> <% ' *** Move To Record: update recordset stats

' set the first and last displayed record rs_first = MM_offset + 1 rs_last = MM_offset + MM_size

If (MM_rsCount <> -1) Then If (rs_first > MM_rsCount) Then rs_first = MM_rsCount End If If (rs_last > MM_rsCount) Then rs_last = MM_rsCount End If End If

' set the boolean used by hide region to check if we are on the last record MM_atTotal = (MM_rsCount <> -1 And MM_offset + MM_size >= MM_rsCount) %> <% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

Dim MM_keepNone Dim MM_keepURL Dim MM_keepForm Dim MM_keepBoth

Dim MM_removeList Dim MM_item Dim MM_nextItem

' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" End If

MM_keepURL="" MM_keepForm="" MM_keepBoth="" MM_keepNone=""

' add the URL parameters to the MM_keepURL string For Each MM_item In Request.QueryString MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepURL = MM_keepURL & MM_nextItem & Server.URLencode(Request.QueryString(MM_item)) End If Next

' add the Form variables to the MM_keepForm string For Each MM_item In Request.Form MM_nextItem = "&" & MM_item & "=" If (InStr(1,MM_removeList,MM_nextItem,1) = 0) Then MM_keepForm = MM_keepForm & MM_nextItem & Server.URLencode(Request.Form(MM_item)) End If Next

' create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL & MM_keepForm If (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1) End If If (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) End If If (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) End If

' a utility function used for adding additional parameters to these strings Function MM_joinChar(firstItem) If (firstItem <> "") Then MM_joinChar = "&" Else MM_joinChar = "" End If End Function %> <% ' *** Move To Record: set the strings for the first, last, next, and previous links

Dim MM_keepMove Dim MM_moveParam Dim MM_moveFirst Dim MM_moveLast Dim MM_moveNext Dim MM_movePrev

Dim MM_urlStr Dim MM_paramList Dim MM_paramIndex Dim MM_nextParam

MM_keepMove = MM_keepBoth MM_moveParam = "index"

' if the page has a repeated region, remove 'offset' from the maintained parameters If (MM_size > 1) Then MM_moveParam = "offset" If (MM_keepMove <> "") Then MM_paramList = Split(MM_keepMove, "&") MM_keepMove = "" For MM_paramIndex = 0 To UBound(MM_paramList) MM_nextParam = Left(MM_paramList(MM_paramIndex), InStr(MM_paramList(MM_paramIndex),"=") - 1) If (StrComp(MM_nextParam,MM_moveParam,1) <> 0) Then MM_keepMove = MM_keepMove & "&" & MM_paramList(MM_paramIndex) End If Next If (MM_keepMove <> "") Then MM_keepMove = Right(MM_keepMove, Len(MM_keepMove) - 1) End If End If End If

' set the strings for the move to links If (MM_keepMove <> "") Then MM_keepMove = Server.HTMLEncode(MM_keepMove) & "&" End If

MM_urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "="

MM_moveFirst = MM_urlStr & "0" MM_moveLast = MM_urlStr & "-1" MM_moveNext = MM_urlStr & CStr(MM_offset + MM_size) If (MM_offset - MM_size < 0) Then MM_movePrev = MM_urlStr & "0" Else MM_movePrev = MM_urlStr & CStr(MM_offset - MM_size) End If %> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=gb2312"> <title>论坛首页</title> <link href="/css.css" rel="stylesheet" type="text/css"> </head>

<body> <table width="775" border="0" align="center" cellpadding="0" cellspacing="0"> <tr class="right-td4"> <td width="25%" height="30">&nbsp;<img src="/images/bar_3.jpg" width="13" height="13" align="ABSMIDDLE" border="0">&nbsp;客户留言讨论系统</td> <td width="50%" height="30" align="center"><a href="/bbs/addbbs.asp" target="_self">发表新帖</a></td> <td width="25%" height="30" align="right">(<span class="style3"></span>—<span class="style3"></span>),共<span class="style3"></span>条&nbsp;</td> </tr> <tr> <td class="right-td2" colspan="3" valign="top"> <table width="98%" border="1" align="center" cellpadding="5" cellspacing="0"> <tr> <td width="56%" height="30" align="center">标 题</td> <td width="16%" height="30" align="center">作 者</td> <td width="18%" height="30" align="center">发表时间</td> <td width="10%" height="30" align="center">点击数</td> </tr> <% While ((Repeat1__numRows <> 0) AND (NOT rs.EOF)) %> <tr> <td height="24"><a href="/bbs/readbbs.asp?Id=<%=(rs.Fields.Item("Id").Value)%>"><%=(rs.Fields.Item("Subject").Value)%></a></td> <td height="24"><%=(rs.Fields.Item("userName").Value)%></td> <td height="24" align="center"><%=(rs.Fields.Item("addTime").Value)%></td> <td height="24" align="center"><%=(rs.Fields.Item("hits").Value)%></td> </tr> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rs.MoveNext() Wend %>

<tr align="RIGHT"> <td height="24" colspan="4"> <% If MM_offset <> 0 Then %> <A HREF="<%=MM_moveFirst%>">始页</A> &nbsp; <A HREF="<%=MM_movePrev%>">前1页</A> <% End If ' end MM_offset <> 0 %> &nbsp; <% If Not MM_atTotal Then %> <A HREF="<%=MM_moveNext%>">后1页</A> &nbsp; <A HREF="<%=MM_moveLast%>">末页</A> <% End If ' end Not MM_atTotal %></td> </tr> </table> </td></tr> </table> </body> </html> <% rs.Close() Set rs = Nothing %>

搜索更多相关主题的帖子: 问题解决 
2005-03-16 15:43
tang688
Rank: 5Rank: 5
等 级:贵宾
威 望:16
帖 子:1219
专家分:35
注 册:2004-12-25
收藏
得分:0 
偶解决不了,原因很简单:
1、长篇大论,没兴趣看。
2、没头没脑无从下手。

2005-03-16 16:27
suyongtao
Rank: 16Rank: 16Rank: 16Rank: 16
等 级:版主
威 望:33
帖 子:8674
专家分:127
注 册:2004-11-6
收藏
得分:0 
怎么个不能预览呀,是不是很慢,还是怎么样,还是什么都看不到说清楚点,

面朝大海,春暖花开!
2005-03-17 14:01
whg8208
Rank: 1
等 级:新手上路
帖 子:4
专家分:0
注 册:2005-3-16
收藏
得分:0 
"无法显示该网页""HTTP500 内部服务器问题"
2005-03-17 15:09
whg8208
Rank: 1
等 级:新手上路
帖 子:4
专家分:0
注 册:2005-3-16
收藏
得分:0 
还有哦,我是对着我买来的书做的,书上是这样做的,但是当我加上服务器类型的时候就没有办法预览了,好奇怪!!
有人告诉我说是要手写服务器类型,可是我是个菜鸟,不知道怎么手写啊!能不能帮忙指点一下!!!?/
2005-03-17 15:12
griefforyou
Rank: 6Rank: 6
等 级:贵宾
威 望:27
帖 子:3336
专家分:0
注 册:2004-4-15
收藏
得分:0 
服务器连接不对吧

天津网站建设 http://www./
2005-03-17 20:35
makebest
Rank: 8Rank: 8
等 级:蝙蝠侠
威 望:3
帖 子:658
专家分:962
注 册:2005-3-17
收藏
得分:0 
原因可能出在这里,你确定有 conn.asp 文件且内容/目录都符合要求吗?
&lt;!--#include file="../Connections/conn.asp" --&gt;
2005-03-18 09:16
suyongtao
Rank: 16Rank: 16Rank: 16Rank: 16
等 级:版主
威 望:33
帖 子:8674
专家分:127
注 册:2004-11-6
收藏
得分:0 
太长了,,,,,,,,,

面朝大海,春暖花开!
2005-03-18 10:22
冰岩
Rank: 1
等 级:新手上路
帖 子:22
专家分:0
注 册:2005-3-3
收藏
得分:0 
以下是引用makebest在2005-3-18 9:16:42的发言: 原因可能出在这里,你确定有 conn.asp 文件且内容/目录都符合要求吗? <!--#include file="../Connections/conn.asp" -->
我支持楼上的看法!
2005-03-18 12:57
快速回复:大虾,这种问题解决得了吗!!??
数据加载中...
 
   



关于我们 | 广告合作 | 编程中国 | 清除Cookies | TOP | 手机版

编程中国 版权所有,并保留所有权利。
Powered by Discuz, Processed in 0.013788 second(s), 7 queries.
Copyright©2004-2024, BCCN.NET, All Rights Reserved