标题:<求助>请大家一定要帮帮我改改这错误内容啊!
取消只看楼主
zgd1986516
Rank: 1
等 级:新手上路
帖 子:14
专家分:0
注 册:2007-6-25
 问题点数:0 回复次数:1 
<求助>请大家一定要帮帮我改改这错误内容啊!
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] 语法错误 (操作符丢失) 在查询表达式 'G_ID =' 中。
/bysj3/bbs/forum/detail.asp, 第 46 行


错误类型:
Microsoft VBScript 编译器错误 (0x800A0400)
缺少语句
/bysj3/bbs/forum/detail.asp, line 485, column 28
If Rer.EOF And Rer.BOF Then ()
---------------------------^
  第46行  Command1.Execute()
   


本主题共有<font color="#FF6600"><b><%=(Rer_total)%></b></font>个回复贴
                    <% End If ' end Not Rer.EOF Or NOT Rer.BOF %>
              [color=Red] 第485行 <% If Rer.EOF And Rer.BOF Then ()  %>
     
               目前还没有回复
                    <% End If ' end Rer.EOF And Rer.BOF %>[/color]<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../Connections/conmx.asp" -->
<%

if(request("ID") <> "") then Command1__Mid = request("ID")

%>
<%
Dim Ret__MMColParam
Ret__MMColParam = "1"
if (Request.QueryString("ID") <> "") then Ret__MMColParam = Request.QueryString("ID")
%>
<%
set Ret = Server.CreateObject("ADODB.Recordset")
Ret.ActiveConnection = MM_conmx_STRING
Ret.Source = "SELECT * FROM tb_guestbook WHERE G_ID = " + Replace(Ret__MMColParam, "'", "''") + ""
Ret.CursorType = 0
Ret.CursorLocation = 2
Ret.LockType = 3
Ret.Open()
Ret_numRows = 0
%>
<%
Dim Rer__MMColParam
Rer__MMColParam = "1"
if (Request.QueryString("ID") <> "") then Rer__MMColParam = Request.QueryString("ID")
%>
<%
set Rer = Server.CreateObject("ADODB.Recordset")
Rer.ActiveConnection = MM_conmx_STRING
Rer.Source = "SELECT *  FROM tb_guestbook  WHERE G_Rid = '" + Replace(Rer__MMColParam, "'", "''") + "'  "
Rer.CursorType = 0
Rer.CursorLocation = 2
Rer.LockType = 3
Rer.Open()
Rer_numRows = 0
%>
<%

set Command1 = Server.CreateObject(")
Command1.ActiveConnection = MM_conmx_STRING
= "UPDATE tb_guestbook  SET Hot =Hot+1  WHERE G_ID =" + Replace(Command1__Mid, "'", "''") + ""
= 1
= 0
Command1.Prepared = true
  第46行  Command1.Execute()

%>


<%
'  *** Recordset Stats, Move To Record, and Go To Record: declare stats variables

' set the record count
Rer_total = Rer.RecordCount

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

' set the first and last displayed record
Rer_first = 1
Rer_last  = Rer_first + Rer_numRows - 1

' if we have the correct record count, check the other stats
If (Rer_total <> -1) Then
  If (Rer_first > Rer_total) Then Rer_first = Rer_total
  If (Rer_last > Rer_total) Then Rer_last = Rer_total
  If (Rer_numRows > Rer_total) Then Rer_numRows = Rer_total
End If
%>
<%
' *** Recordset Stats: if we don't know the record count, manually count them

If (Rer_total = -1) Then

  ' count the total records by iterating through the recordset
  Rer_total=0
  While (Not Rer.EOF)
    Rer_total = Rer_total + 1
    Rer.MoveNext
  Wend

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

  ' set the number of rows displayed on this page
  If (Rer_numRows < 0 Or Rer_numRows > Rer_total) Then
    Rer_numRows = Rer_total
  End If

  ' set the first and last displayed record
  Rer_first = 1
  Rer_last = Rer_first + Rer_numRows - 1
  If (Rer_first > Rer_total) Then Rer_first = Rer_total
  If (Rer_last > Rer_total) Then Rer_last = Rer_total

End If
%>
<%
' *** Move To Record and Go To Record: declare variables

Set MM_rs    = Rer
MM_rsCount   = Rer_total
MM_size      = Rer_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
  r = Request.QueryString("index")
  If r = "" Then r = Request.QueryString("offset")
  If r <> "" Then MM_offset = Int(r)

  ' 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
  i = 0
  While ((Not MM_rs.EOF) And (i < MM_offset Or MM_offset = -1))
    MM_rs.MoveNext
    i = i + 1
  Wend
  If (MM_rs.EOF) Then MM_offset = i  ' set MM_offset to the last possible record

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
  i = MM_offset
  While (Not MM_rs.EOF And (MM_size < 0 Or i < MM_offset + MM_size))
    MM_rs.MoveNext
    i = i + 1
  Wend

  ' if we walked off the end of the recordset, set MM_rsCount and MM_size
  If (MM_rs.EOF) Then
    MM_rsCount = i
    If (MM_size < 0 Or MM_size > MM_rsCount) Then MM_size = MM_rsCount
  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
  i = 0
  While (Not MM_rs.EOF And i < MM_offset)
    MM_rs.MoveNext
    i = i + 1
  Wend
End If
%>
<%
' *** Move To Record: update recordset stats

' set the first and last displayed record
Rer_first = MM_offset + 1
Rer_last  = MM_offset + MM_size
If (MM_rsCount <> -1) Then
  If (Rer_first > MM_rsCount) Then Rer_first = MM_rsCount
  If (Rer_last > MM_rsCount) Then Rer_last = MM_rsCount
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

' create the list of parameters which should not be maintained
MM_removeList = "&index="
If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "="
MM_keepURL="":MM_keepForm="":MM_keepBoth="":MM_keepNone=""

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

' add the Form variables to the MM_keepForm string
For Each Item In Request.Form
  NextItem = "&" & Item & "="
  If (InStr(1,MM_removeList,NextItem,1) = 0) Then
    MM_keepForm = MM_keepForm & NextItem & Server.URLencode(Request.Form(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)
if (MM_keepURL <> "")  Then MM_keepURL  = Right(MM_keepURL, Len(MM_keepURL) - 1)
if (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1)

' 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

MM_keepMove = MM_keepBoth
MM_moveParam = "index"

' if the page has a repeated region, remove 'offset' from the maintained parameters
If (MM_size > 0) Then
  MM_moveParam = "offset"
  If (MM_keepMove <> "") Then
    params = Split(MM_keepMove, "&")
    MM_keepMove = ""
    For i = 0 To UBound(params)
      nextItem = Left(params(i), InStr(params(i),"=") - 1)
      If (StrComp(nextItem,MM_moveParam,1) <> 0) Then
        MM_keepMove = MM_keepMove & "&" & params(i)
      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 = MM_keepMove & "&"
urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "="
MM_moveFirst = urlStr & "0"
MM_moveLast  = urlStr & "-1"
MM_moveNext  = urlStr & Cstr(MM_offset + MM_size)
prev = MM_offset - MM_size
If (prev < 0) Then prev = 0
MM_movePrev  = urlStr & Cstr(prev)
%>
<%
Dim Rer_TFMcurrentPage
Dim Rer_TFMtotalPages
If MM_size > 0 Then
Rer_TFMcurrentPage = Round(Rer_last/MM_size + .4999)
Rer_TFMtotalPages = Round(Rer_total/MM_size + .4999)
End If
%>
<%
Function T3_AutoHyperlink2(strContent, strTarget)
    If NOT IsNull(strContent) OR strContent <> "" then
        T3_AutoHyperlink2 = Replace(strContent, "http://www", "www")
        Set RegHyperlink = NEW RegExp
        RegHyperlink.Pattern = "www.\b[^\s]*\S"
        RegHyperlink.Global = True
        Set HyperlinkMatches = RegHyperlink.Execute(T3_AutoHyperlink2)
        For Each Hyperlink In HyperlinkMatches
            T3_AutoHyperlink2 = Replace(T3_AutoHyperlink2,Hyperlink.Value, "<a href=""http://" & Hyperlink.Value & """ target=""" & strTarget & """>http://" & Hyperlink.Value & "</a>")
        Next
        RegHyperlink.Pattern = "\w+((-\w+)|(\.\w+))*\@\w+((\.|-)\w+)*\.(co.uk|com|net|org|gov|edu)"
        RegHyperlink.Global = True
        Set EmailMatches = RegHyperlink.Execute(T3_AutoHyperlink2)
        For Each Email In EmailMatches
            T3_AutoHyperlink2 = Replace(T3_AutoHyperlink2,Email.Value, "<a href=""mailto:" & Email.Value & """>" & Email.Value & "</a>")
        Next
        T3_AutoHyperlink2 = Replace(T3_AutoHyperlink2,chr(13),"<br>")
    Else
        T3_AutoHyperlink2 = ""
    End If
End Function
%>
<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>                                        
function DoWhiteSpace(str)                                                
    DoWhiteSpace = Replace((Replace(str, vbCrlf, "<br>")), chr(32)&chr(32), "??")            
End Function                                                        
</SCRIPT>
<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>                                        
function CI_Preserve(str)                
on error resume next                
CI_Preserve = Replace(str,Chr(13),"<br>")        
End Function                                                        
</SCRIPT>                                                        
<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>                                        
function CI_EncodePreserve(str)                
on error resume next                
tempStr = Server.HTMLEncode(str)        
CI_EncodePreserve = Replace(tempStr,Chr(13),"<br>")        
End Function                                                        
</SCRIPT>
<SCRIPT RUNAT=SERVER LANGUAGE=VBSCRIPT>                                        
function DoWhiteSpace(str)                                                
    DoWhiteSpace = Replace((Replace(str, vbCrlf, "<br>")), chr(32)&chr(32), "??")            
End Function                                                        
</SCRIPT>                                                        
<HTML>
<HEAD>
<TITLE>DreamWeaverMX/UltraDev教程资讯网站</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<LINK
href="../images/123.files/fontstyle.css" type=text/css rel=stylesheet>
<META content=针对动态IP用户的专业级动态域名(DNS)服务 name=description>
<META

name=keywords>
<META content="Microsoft FrontPage 5.0" name=GENERATOR>
<link rel="stylesheet" href="../css/fontstyle.css" type="text/css">
</HEAD>
<BODY text=#000000 bgColor=#ffffff leftMargin=0 topMargin=1 background="../images/bg.gif">
<style>
body {SCROLLBAR-FACE-COLOR: #990000; SCROLLBAR-HIGHLIGHT-COLOR: #FFFFFF; SCROLLBAR-SHADOW-COLOR: #FFFFFF; SCROLLBAR-3DLIGHT-COLOR: #990000; SCROLLBAR-ARROW-COLOR:  #FFFFFF; SCROLLBAR-TRACK-COLOR: #e7e7e7; SCROLLBAR-DARKSHADOW-COLOR: #666666; }
</style><center>
  <table width="777" border="0" cellspacing="0" cellpadding="0"   >
    <td width="777" height="148" background="../images/top.jpg" ><font color="#ffffff" size="2" face="Geneva, Arial, Helvetica, san-serif"><span
      class=font9><font color=#e7e7e7 class="font9" >
</font><font color="#ffffff" size="2" face="Geneva, Arial, Helvetica, san-serif"><font color=#e7e7e7 class="font9" >
</font></font><font color="#ffffff" size="2" face="Geneva, Arial, Helvetica, san-serif"><font color="#ffffff" size="2" face="Geneva, Arial, Helvetica, san-serif"><font color=#e7e7e7 class="font9" >
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.,0,19,0" width="777" height="148" title="object" >
  <param name="movie" value="../images/xing.swf" />
  <param name="quality" value="high" />
  <param name="wmode" value="transparent">
  <embed src="../images/xing.swf" quality="high" pluginspage="http://www. type="application/x-shockwave-flash" width="777" height="152"></embed>
</object>
</font></font></font><font color=#e7e7e7 class="font9" >    </font></span></font></td>
  </tr>
  </table>
</center>
<table cellspacing=0 cellpadding=0 width=777 border=0 align="center">
  <tbody>
  <tr bgcolor=#333333>
    <td width="776"><img height=1 src="../images/123.files/longest_dottedline.gif"
      width=776></td>
  </tr>
  <tr bgcolor=#666666>
    <td valign=center bgcolor=#990000 width="776"
      height=10>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td height="20" bgcolor="#0099FF"><span class="font9"><font color="#FFFFff">
            <font color="#990000">?</font><%=now%><font color="#ffffff">??欢迎来到软件工程论坛中心</font></font></span>
            <div align="center"><font size="2" color="#FFFFFF" face="Geneva, Arial, Helvetica, san-serif" class="font9">
            </font></div></td>
          </tr>
      </table>
    </td>
    <td width=1 background=../images/123.files/dotline.gif bgcolor=#999999
    rowspan=4><img height=20 alt="" src="" width=1 border=0></td>
  </tr>
  <tr bgcolor=#666666>
    <td valign=center background=../images/123.files/longest_dottedline.gif bgcolor=#990000 width="776">
    </td>
  </tr>
  <tr bgcolor=#666666>
  
  </tr>
  <tr bgcolor=#666666>
    <td width="776"><img height=1 src="../images/123.files/longest_dottedline.gif"
      width=776></td>
  </tr>
  <tr bgcolor=#999999>
    <td valign=center bgcolor=#666666 width="776">
      <div align="center"><font color="#ffffff" size="2" face="Geneva, Arial, Helvetica, san-serif"><span
      class=font9><a class=1
      href="../default.asp"><font face="Verdana, Arial, Helvetica, sans-serif">主
        页</font></a> <font face="Verdana, Arial, Helvetica, sans-serif">|</font><font face="Verdana, Arial, Helvetica, sans-serif">
        <a class=1
      href="../basic/default.asp">新手入门</a> |</font> <font face="Verdana, Arial, Helvetica, sans-serif"><a class=1
      href="../asp/default.asp">ASP教程</a> |<font color=#e7e7e7> <a
      class=1
      href="../ <font color="#FFFFFF">|</font><font color="#FFFF00">
        </font> <a class=1
      href="../php/default.asp">PHP教程</a> <font color="#FFFFFF">|</font> <a class=1
      href="../cfml/default.asp">CFML教程</a><font color="#FFFFFF"> |</font> <a class=1
      href="../advance/Default.asp">开发进阶</a><font color="#FFFFFF"> |</font> <a class=1
      href="../database/default.asp">数据库教程</a> <font color="#FFFFFF">| </font><a class=1
      href="../extension/default.asp">插件教程</a> <font color="#FFFFFF">|</font>
        <a class=1
      href="default.asp">论坛中心</a> </font></font><font color="#e7e7e7" size="2" face="Verdana, Arial, Helvetica, sans-serif" class="font9">
        <font color="#FFFFFF">|</font> </font><font color=#e7e7e7 class="font9" ><a class=1
      href="../flashmx/default.asp">FLASHMX</a></font></span></font></div>
    </td>
    <td width=1 background=../images/123.files/dotline.gif><img height=20
      alt="" src="" width=1 border=0></td>
  </tr>
  <tr bgcolor=#999999>
    <td valign=bottom bgcolor=#333333 width="776"><img height=1

      src="../images/123.files/longest_dottedline.gif" width=776></td>
  </tr>
  </tbody>
</table>
<table width="776" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor="#FFFFFF">
  <tr>
    <td background="../images/123.files/dotline.gif" width="1"><img src="../images/123.files/dotline.gif" width="1" height="3"></td>
    <td valign="top">
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr>
          <td></td>
        </tr>
        <tr>
          <td height="20" class="font9">  <font face="Geneva, Arial, Helvetica, san-serif" color="#006600"><b><font color="#000000">Guide</font></b><font color="#000000">:</font></font><font face="Geneva, Arial, Helvetica, san-serif"><a href="../default.asp">HOMEPAGE</a></font>&gt;&gt;<a href="default.asp">论坛中心</a>&gt;&gt;主题内容页</td>
        </tr>
        <tr>
          <td background="../images/123.files/long_dottedline.gif">
            <div align="center"><img src="../images/123.files/long_dottedline.gif" width="361" height="1"></div>
          </td>
        </tr>
        <tr>
          <td valign="top">
            <div align="center"><br>
              <table width="705" border="0" cellspacing="1" cellpadding="3">
                <tr>
                  <td width="75" class="font9">页面导航→</td>
                  <td class="font9" width="362">
                    <% If Not Rer.EOF Or Not Rer.BOF Then %>
                    <%
TFM_MiddlePages = 5
TFM_startLink = MM_offset/MM_size - int(TFM_middlePages/2)
TFM_endLink = MM_offset/MM_size + int(TFM_middlePages/2)
If TFM_MiddlePages/2 <> int(TFM_MiddlePages/2) Then TFM_endLink = TFM_endLink + 1
If TFM_startLink < 0 then
   TFM_startLink = 0
   TFM_endLink = TFM_middlePages
End If
TFM_LimitCounter = 0
For i = 1 to Rer_total Step MM_size
TFM_LimitCounter = TFM_LimitCounter + 1
TFM_LimitPageEndCount = i + MM_size - 1
if TFM_LimitPageEndCount > Rer_total Then TFM_LimitPageEndCount = Rer_total
If TFM_LimitCounter > TFM_startLink AND TFM_LimitCounter <= TFM_endLink Then
if i <> MM_offset + 1 then
Response.Write("<a href=""" & Request.ServerVariables("URL") & "?" & MM_keepMove & "offset=" & i-1 & """>")
Response.Write(TFM_LimitCounter & "</a>")
else
Response.Write("<b>" & TFM_LimitCounter & "</b>")
End if
if(TFM_LimitPageEndCount <> Rer_total AND TFM_endLink <> TFM_LimitCounter) then Response.Write("|")
end if
next
%>
                    本主题共有<font color="#FF6600"><b><%=(Rer_total)%></b></font>个回复贴
                    <% End If ' end Not Rer.EOF Or NOT Rer.BOF %>
                    <% If Rer.EOF And Rer.BOF Then ()  %>
                    目前还没有回复
                    <% End If ' end Rer.EOF And Rer.BOF %>
                  </td>
                  <td width="241" class="font9">
                    <div align="center"><a href="reply.asp?ID=<%=(Ret.Fields.Item("G_ID").Value)%>">回复主题</a>
                      <a href="new.asp">发布新主题</a> <a href="search.asp">论坛搜索</a></div>
                  </td>
                </tr>
              </table>
              <table width="700" border="0" cellspacing="0" cellpadding="0" class="border_lr">
                <tr bgcolor="#FFFFFF">
                  <td colspan="2" class="font9" height="2"><img src="../images/700.gif" width="700" height="1"></td>
                </tr>
                <tr bgcolor="#0099FF">
                  <td colspan="2" class="font9" height="20">
                    <div align="left">主 题:<%=(Ret.Fields.Item("G_Subject").Value)%> <font color="#ffffff" size="2" face="Geneva, Arial, Helvetica, san-serif"><font color="#ffffff" size="2" face="Geneva, Arial, Helvetica, san-serif"><font color=#e7e7e7 class="font9" >
                    </font></font></font></div>
                  </td>
                </tr>
                <tr>
                  <td colspan="2" class="font9" bgcolor="#FFFFFF"><img src="../images/700.gif" width="700" height="1"></td>
                </tr>
                <tr>
                  <td class="font9" bgcolor="eeeeeee" width="246">
                    <div align="left"><font color="#990000"><b>发布:<b></b><%=(Ret.Fields.Item("G_Name").Value)%></b></font></div>
                  </td>
                  <td class="font9" bgcolor="eeeeeee" width="454" height="20">
                    <div align="right"><a href="mailto:<%=(Ret.Fields.Item("G_Email").Value)%>">Emai</a>l
                      <%=(Ret.Fields.Item("G_Data").Value)%> </div>
                  </td>
                </tr>
                <tr bgcolor="#FFFFFF">
                  <td class="font9" colspan="2"><img src="../images/700.gif" width="700" height="1"></td>
                </tr>
                <tr>
                  <td colspan="2" height="29" valign="top">
                    <table width="100%" border="0" cellspacing="0" cellpadding="10" bgcolor="#999999">
                      <tr>
                        <td bgcolor="#FFFFFF" width="100%" class="pg23" style="WORD-WRAP: break-word">
                          <%=DoWhiteSpace(Server.HTMLEncode((Ret.Fields.Item("G_Content").Value)))%></td>
                      </tr>
                    </table>
                  </td>
                </tr>
                <%
While ((Repeat1__numRows <> 0) AND (NOT Rer.EOF))
%>
                <tr>
                  <td class="font9" bgcolor="#FFFFFF" colspan="2"><img src="../images/700.gif" width="700" height="1"></td>
                </tr>
                <% If Not Rer.EOF Or Not Rer.BOF Then %>
                <tr>
                  <td class="font9" bgcolor="#eeeeeee" width="246">
                    <p><font color="#006600"><b>回复:<%=(Rer.Fields.Item("G_Name").Value)%></b></font></p>
                  </td>
                  <td class="font9" bgcolor="#eeeeeee" width="454" height="20">
                    <div align="right"><a href="mailto:<%=(Rer.Fields.Item("G_Email").Value)%>">Email</a>
                      <font color="#006600"><%=(Rer.Fields.Item("G_Data").Value)%></font> </div>
                  </td>
                </tr>
                <tr bgcolor="#FFFFFF">
                  <td class="font9" colspan="2"><img src="../images/700.gif" width="700" height="1"></td>
                </tr>
                <tr>
                  <td colspan="2" class="pg23">
                    <div align="center">
                      <table width="700" border="0" cellspacing="0" cellpadding="10" bgcolor="#999999">
                        <tr >
                          <td bgcolor="#FFFFFF" width="664" style="WORD-WRAP: break-word" class="pg23" >
                            <%=DoWhiteSpace(Server.HTMLEncode((Rer.Fields.Item("G_Content").Value)))%></td>
                        </tr>
                      </table>
                    </div>
                  </td>
                </tr>
                <% End If ' end Not Rer.EOF Or NOT Rer.BOF %>
                <%
  Repeat1__index=Repeat1__index+1
  Repeat1__numRows=Repeat1__numRows-1
  Rer.MoveNext()
Wend
%>
                <tr bgcolor="#FFFFFF">
                  <td colspan="2" class="font9" height="2"><img src="../images/700.gif" width="700" height="1"></td>
                </tr>
                <tr>
                  <td class="font9" colspan="2"><img src="../images/700.gif" width="700" height="1"></td>
                </tr>
                <tr bgcolor="#0066FF">
                  <td class="font9" colspan="2"> </td>
                </tr>
                <tr bgcolor="#FFFFFF">
                  <td class="font9" colspan="2" height="2"><img src="../images/700.gif" width="700" height="1"></td>
                </tr>
              </table>
              <table width="700" border="0" cellspacing="1" cellpadding="3">
                <tr>
                  <td width="75" class="font9">页面导航→</td>
                  <td class="font9" width="362">
                    <% If Not Rer.EOF Or Not Rer.BOF Then %>
                    本主题共有<font color="#FF6600"><b><%=(Rer_total)%></b></font>个回复贴<b>|</b>
                    <%
TFM_MiddlePages = 5
TFM_startLink = MM_offset/MM_size - int(TFM_middlePages/2)
TFM_endLink = MM_offset/MM_size + int(TFM_middlePages/2)
If TFM_MiddlePages/2 <> int(TFM_MiddlePages/2) Then TFM_endLink = TFM_endLink + 1
If TFM_startLink < 0 then
   TFM_startLink = 0
   TFM_endLink = TFM_middlePages
End If
TFM_LimitCounter = 0
For i = 1 to Rer_total Step MM_size
TFM_LimitCounter = TFM_LimitCounter + 1
TFM_LimitPageEndCount = i + MM_size - 1
if TFM_LimitPageEndCount > Rer_total Then TFM_LimitPageEndCount = Rer_total
If TFM_LimitCounter > TFM_startLink AND TFM_LimitCounter <= TFM_endLink Then
if i <> MM_offset + 1 then
Response.Write("<a href=""" & Request.ServerVariables("URL") & "?" & MM_keepMove & "offset=" & i-1 & """>")
Response.Write(TFM_LimitCounter & "</a>")
else
Response.Write("<b>" & TFM_LimitCounter & "</b>")
End if
if(TFM_LimitPageEndCount <> Rer_total AND TFM_endLink <> TFM_LimitCounter) then Response.Write("|")
end if
next
%>
                    <% End If ' end Not Rer.EOF Or NOT Rer.BOF %>
                  </td>
                  <td colspan="4" class="font9">
                    <div align="center"><a href="reply.asp?ID=<%=(Ret.Fields.Item("G_ID").Value)%>">回复主题</a>
                      <a href="#" class="font9">发布新主题</a> <a href="search.asp">论坛搜索</a>
                    </div>
                  </td>
                </tr>
              </table>
              <p> </p>
              <br>
            </div>
          </td>
        </tr>
      </table>
    </td>
    <td background="../images/123.files/dotline.gif" width="1"><img src="../images/123.files/dotline.gif" width="1" height="3"></td>
  </tr>
</table>
<TABLE cellSpacing=0 cellPadding=0 width=776 border=0 align="center">
  <TBODY>
  <TR>
    <TD width=775 bgColor=#333333 height=11>
      <div align="center"><FONT class=font9
      color=#ffffff>????????<font color="#FFFFFF" face="Geneva, Arial, Helvetica, san-serif">Copyright
        ? 2003 www. All right reserved . The site powered by MxerStudio.</font></FONT></div>
    </TD>
    <TD width=1 background=../images/123.files/dotline.gif bgColor=#333333
      height=11><IMG height=20 alt="" src="" width=1
border=0></TD>
  </TR>
  </TBODY>
</TABLE>
</BODY>
</HTML>
<%
Ret.Close()
%>
<%
Rer.Close()
%>

[[it] 本帖最后由 zgd1986516 于 2008-3-2 20:51 编辑 [/it]]
搜索更多相关主题的帖子: Microsoft Rer 改改 detail forum 
2008-03-02 20:31
zgd1986516
Rank: 1
等 级:新手上路
帖 子:14
专家分:0
注 册:2007-6-25
得分:0 
第一个错误是因为G_ID没有得到值,怎样才能得到他的值呢?去了()还是没有用啊?

[[it] 本帖最后由 zgd1986516 于 2008-3-3 15:02 编辑 [/it]]
2008-03-03 14:55



参与讨论请移步原网站贴子:https://bbs.bccn.net/thread-201673-1-1.html




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

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