注册 登录
编程论坛 ASP技术论坛

老问题,再请教高手!

发布于 2008-07-15 15:00, 701 次点击
页面出现Microsoft VBScript 编译器错误 错误 '800a03f6'

缺少 'End'

/iisHelp/common/500-100.asp,行242

Microsoft OLE DB Provider for ODBC Drivers 错误 '80004005'

[Microsoft][ODBC Microsoft Access Driver] 操作必须使用一个可更新的查询。
/admin/type.asp,行82
是什么问题啊?我搞了半天还是没有解决,我的是windows2000操作系统,ie5.0,access数据库。请高手帮忙啊,急啊,在线等。。。
5 回复
#2
SkyGull2008-07-15 15:14
代码粘出来......
#3
2008-07-15 15:29
<%@ Language=VBScript%>
<!--#include file=include/conn.asp -->
<!--#include file=include/function.asp -->
<!--#include file=include/con1.asp -->
<!--#include file="admin/char.inc"-->
<%
function nohtml(str)
    dim re
    Set re=new RegExp
    re.IgnoreCase =true
    re.Global=True
    re.Pattern="(\<.[^\<]*\>)"
    str=re.replace(str," ")
    re.Pattern="(\<\/[^\<]*\>)"
    str=re.replace(str," ")
    nohtml=str
    set re=nothing
end function
%>
<%
typeid=checkstr(request("typeid"))
if typeid="" then
Response.Write "<script>alert('未指定参数');history.back()</script>"
response.end
else
if not IsNumeric(typeid) then
 response.write "<script>alert('非法参数');history.back()</script>"
 response.end
else
dim ttypename
set rs5=server.CreateObject("ADODB.RecordSet")
rs5.Source="select * from type where typeid=" & typeid &" order by typeorder"
rs5.Open rs5.Source,conn,1,1
ttypename=rs5("typename")
rs5.Close
set rs5=nothing

%>

<%
dim typeid
typeid=checkstr(request("typeid"))
set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from BigClass where typeid="&typeid&" order by bigclassorder"
rs.Open rs.Source,conn,1,1
i=1
Dim ArrayBigClassID(10000),ArrayBigClassName(10000),ArrayBigClassView(10000)
if not rs.EOF then
rseof=1
end if
end if
while not rs.EOF
abcount=rs.RecordCount
BigClassView=rs("BigClassView")
BigClassID=rs("BigClassID")

BigClassName=trim(rs("BigClassName"))
BigClasszs=rs("BigClasszs")

ArrayBigClassView(i)=BigClassView
ArrayBigClassID(i)=BigClassID
ArrayBigClassName(i)=BigClassName

i=i+1

rs.MoveNext
wend
rs.close

%>

<html>

<head>
<meta http-equiv="Content-Language" content="zh-cn">

<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title><%=ttypeName%>__<%=jjgn%></title>
<LINK href=index.css rel=stylesheet>
<script language="JavaScript1.2">
<!--



function makevisible(cur,which){
if (which==0)
cur.filters.alpha.opacity=100
else
cur.filters.alpha.opacity=20
}

function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<style type="text/css">
<!--
body {
    margin-left: 0px;
    margin-right: 0px;
}
-->
</style></head>

<body topmargin="0" marginheight="0" background="img/bg.gif">
<!--#include file=include/top1.asp -->
<%
 dim typename
    typeid=checkstr(request("typeid"))
    set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from type where typeid="&typeid&" order by typeorder"
rs.Open rs.Source,conn,1,1
mode=rs("mode")
typename=rs("typename")
rs.close
set rs=nothing%>
<table width="792" align="center" bgcolor="#FFFFFF" cellpadding="0" cellspacing="0" style="border-left: 1px solid #cccccc; border-right: 1px solid #cccccc">
  <tr valign="top">
    <td width="200" bgcolor="#f4f4f4">
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr bordercolor="#999999">
          <td align="center" valign="middle"><img name="" src="" width="1" height="8" alt=""></td>
        </tr>
        <tr>
          <td height="490" valign="top">
            <table width="90%"  align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: 1px solid #cccccc">
              <tr>
                <td><div align="center"><img src="img/type_left_01.gif" width="180" height="29"></div></td>
              </tr>
              <tr>
                <td class="6"><table width="100%" align="center" cellpadding="0" cellspacing="6">
                  <tr>
                    <td>
                      <%
    dim mode
    typeid=checkstr(request("typeid"))
    set rs=server.CreateObject("ADODB.RecordSet")
rs.Source="select * from type where typeid="&typeid&" order by typeorder"
rs.Open rs.Source,conn,1,1
mode=rs("mode")
rs.close
set rs=nothing
    if mode=5 then
    set rs=conn.execute("SELECT * FROM bigclass where typeid="&typeid&" order by bigclassorder")
    if not rs.EOF then
    do while not rs.eof

    %>
                      <table border="0" cellpadding="3" cellspacing="0" style="border-collapse: collapse" width="100%" id="AutoNumber2">
                        <tr>
                          <td colspan="2">
                            <img src="img/arrow00.gif" width="9" height="11">
                            <%if not Rs.eof then%>
                             <a href="bigclass.asp?typeid=<%=typeid%>&bigclassid=<%=Rs("bigclassid")%>"><%=Rs("bigclassname")%></a> </td>
                        </tr>
                        <%set nrs=conn.execute("SELECT * FROM smallclass where bigclassid="&cstr(rs("bigclassid"))&" order by smallclassorder")%>
                        <%do while not nrs.eof%>
                        <tr>
                          <td width=100% align=center valign="middle">
                            <%if not nRs.eof then%>
                            <a href="SmallClass.asp?typeid=<%=typeid%>&BigClassID=<%=nrs("bigclassid")%>&smallclassid=<%=nrs("smallclassid")%>"><%=nRs("smallclassname")%></a> </td>
                          <%nrs.movenext   
             end if %>
                        </tr>
                        <%loop
            nRs.Close
           set nRs=nothing
            %>
                      </table>
                      <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" bordercolor="<%=border%>" width="105%" id="AutoNumber2" height="11">
                        <tr>
                          <td height=1 align=center></td>
                        </tr>
                      </table>
                      <%rs.movenext   
    end if
      loop
    rs.close
%>
                      <%else%>
                      <table cellpadding=3 cellspacing=0 width=100% border=0 style="border-collapse: collapse">
                        <tr>
                          <td height="22">    <font color="#000000">暂无大类</font> </td>
                        </tr>
                      </table>
                      <%end if%>
                      <%else%>
                      <%  
typeid=checkstr(request("typeid"))
    set rs=conn.execute("SELECT * FROM bigclass where typeid="&typeid&" order by bigclassorder")
    do while not rs.eof
%>
                      <table width="100%" border="0" cellpadding="3" cellspacing="0" id="AutoNumber2" style="border-collapse: collapse">
                        <tr>
                          <td height=22 colspan="2">
                            <img src="img/arrow00.gif" width="9" height="11">
                            <%if not Rs.eof then%>
                            <a href="bigclass.asp?typeid=<%=typeid%>&bigclassid=<%=Rs("bigclassid")%>"><%=Rs("bigclassname")%></a></td>
                        </tr>
                        <%set nrs=conn.execute("SELECT * FROM smallclass where bigclassid="&cstr(rs("bigclassid"))&" order by smallclassorder")%>
                        <%do while not nrs.eof%>
                        <tr>
                          <td width=50% align=center valign="middle">
                            <%if not nRs.eof then%>
                            <a href="SmallClass.asp?typeid=<%=typeid%>&BigClassID=<%=nrs("bigclassid")%>&smallclassid=<%=nrs("smallclassid")%>"><%=nRs("smallclassname")%></a> </td>
                          <%nrs.movenext   
             end if %>
                          <td width=50% align=center valign="middle">
                            <%if not nRs.eof then%>
                            <a href="SmallClass.asp?typeid=<%=typeid%>&BigClassID=<%=nrs("bigclassid")%>&smallclassid=<%=nrs("smallclassid")%>"><%=nRs("smallclassname")%></a> </td>
                          <%nRs.movenext
             end if%>
                        </tr>
                        <%loop
            nRs.Close
           set nRs=nothing
            %>
                      </table>
                      <%rs.movenext   
    end if
    loop  
    rs.close
%>
                      <%end if%>
                    </td>
                  </tr>
                </table></td>
              </tr>
            </table>
            <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" id="AutoNumber4">
              <tr>
                <td width="100%" align=center><img name="" src="" width="1" height="8" alt=""></td>
              </tr>
          </table>         
            <table width="90%" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" id="AutoNumber4" style="border: 1px solid #cccccc">
              <tr>
                <td width="100%" align=center><img src="img/type_left_02.gif" width="180" height="29"></td>
              </tr>
              <tr>
                <td align=center><img name="" src="" width="1" height="8" alt=""></td>
              </tr>
              <tr>
                <td align=center><%if search="1" then%>
                  <!--#include file=search.asp-->
                  <%else%>
                  <!--#include file=search1.asp-->
                <%end if%></td>
              </tr>
              <tr>
                <td align=center><img name="" src="" width="1" height="8" alt=""></td>
              </tr>
            </table>            
            <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0" id="AutoNumber4">
              <tr>
                <td width="100%" align=center><img name="" src="" width="1" height="8" alt=""></td>
              </tr>
            </table>            
            <table width="90%" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: 1px solid #cccccc">
              <tr>
                <td><div align="center"><strong><font color="#000000"><img src="img/type_left_03.gif" width="180" height="29"></font></strong></div></td>
              </tr>
              <tr>
                <td><table width="100%" align="center" cellpadding="0" cellspacing="6" bgcolor="#FFFFFF" id="AutoNumber4">
                  <tr>
                    <td width="100%" height="20" align=center bgcolor="#FFFFFF"><br>
                        <%
set rs3=server.CreateObject("ADODB.RecordSet")
if uselevel=1 then
if Request.cookies("key")="super" or Request.cookies("key")="typemaster" or Request.cookies("key")="bigmaster" or Request.cookies("key")="smallmaster" or Request.cookies("key")="check" then
rs3.Source ="select top " & top_img & " * from News where picnews=1 and checkked=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
if Request.cookies("key")="" then
rs3.Source ="select top " & top_img & " * from News where picnews=1 and checkked=1 and newslevel=0 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
if Request.cookies("key")="selfreg" then
    if Request.cookies("reglevel")=3 then
rs3.Source ="select top " & top_img & " * from News where picnews=1 and checkked=1 and newslevel<=3 and typeid="&typeid&" and picname is not null order by NewsID DESC"
    end if
    if Request.cookies("reglevel")=2 then
rs3.Source ="select top " & top_img & " * from News where picnews=1 and checkked=1 and newslevel<=2 and typeid="&typeid&" and picname is not null order by NewsID DESC"
    end if
    if Request.cookies("reglevel")=1 then
rs3.Source ="select top " & top_img & " * from News where picnews=1 and checkked=1 and newslevel<=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
    end if
end if
else
rs3.Source ="select top " & top_img & " * from News where picnews=1 and checkked=1 and typeid="&typeid&" and picname is not null order by NewsID DESC"
end if
rs3.Open rs3.Source,conn,1,1
if not rs3.EOF then
while not rs3.EOF
fileExt=lcase(getFileExtName(rs3("picname")))
Content=rs3("Content")
content=replace(content,"[[","<")
content=replace(content,"]]",">")
%>
                        <table width="90%" border="0" cellspacing="0" cellpadding="3" align="center" style="TABLE-LAYOUT: fixed">
                          <tr>
                            <td><a href="ReadNews.asp?NewsID=<%=rs3("NewsID")%>" target=_blank title="<%=rs3("title")%>">
                              <%if fileext="jpg" or fileext="bmp" or fileext="png" or fileext="gif" then%>
                              <img  src="uploadfile/<%=rs3("picname")%>" width="65" height="65" align="left" class="border">
                              <%end if%>
                              <%if fileext="swf" then%>
                              <object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000'  codebase='http://download.,0,0,0' width="65" height="65" border=0 align="left">
                                <param name=movie value="uploadfile/<%=rs3("picname")%>">
                                <param name=quality value=high>
                                <param name='Play' value='-1'>
                                <param name='Loop' value='0'>
                                <param name='Menu' value='-1'>
                                <embed src="uploadfile/<%=rs3("picname")%>" width="65" height="65" border=0 align="left" pluginspage='http://www.' type='application/x-shockwave-flash'></embed>
                              </object>
                              <%end if%>
                              <%=rs3("title")%></a></td>
                          </tr>
                        </table>
                        <%
rs3.MoveNext
wend
else
Response.Write "<table width=""100%"" border=""0"" cellspacing=""0"" cellpadding=""0"" align=""center"" style=""TABLE-LAYOUT: fixed""><tr><td width=100% align=center height=18>暂无</td></tr></table>"
end if
rs3.close
set rs3=nothing

%>
                    </td>
                  </tr>
                </table></td>
              </tr>
            </table></td>
        </tr>
      </table>
    </td>
    <td bgcolor="#CCCCCC"><img name="" src="" width="1" height="1" alt=""></td>
    <td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
      <tr>
        <td bgcolor="#F4F4F4" ><img name="" src="" width="1" height="8" alt=""></td>
      </tr>
      <tr>
        <td height="30" background="img/type_bg.gif" class="6">  <img src="img/type01.gif" width="12" height="12" align="absmiddle">  当前位置: <a href="./">网站首页 - </a><%=typename%> </td>
      </tr>
      <tr>
        <td>
          <div align="center">
            <script language=javascript src=./admin/banner/ads.asp?place=1></script>
          </div>
          <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%" id="AutoNumber3">
            <tr>
              <td height="52" valign=top>
                <%if mode<>4  and  mode<>1 then%>
                <%
  if rseof=1 then
for i=1 to abcount
BigClassID=ArrayBigClassID(i)
BigClassName=ArrayBigClassName(i)
BigClassview=ArrayBigClassview(i)
if ArrayBigClassView(i)=1 then
%>
                <table border="0" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber5">
                  <tr>
                    <td width="495" height="30" background="img/type_bg.gif" class="6"> <img src="img/type02.gif" width="9" height="9" align="absmiddle">  <%=BigClassName%></td>
                    <td width="100" background="img/type_bg.gif"><div align="center"><a class=class href='BigClass.asp?typeid=<%=typeid%>&BigClassid=<%=BigClassid%>'><img src="images/more.gif" border="0" alt="更多<%=BigClassName%>"></a></div></td>
                  </tr>
                  <%set rs3=server.CreateObject("ADODB.RecordSet")
  if uselevel=1 then
if Request.cookies("key")="super" or Request.cookies("key")="typemaster" or Request.cookies("key")="bigmaster" or Request.cookies("key")="smallmaster" or Request.cookies("key")="check" then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1) order by newsid DESC"
end if
if Request.cookies("key")="" then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel=0) order by newsid DESC"
end if
if Request.cookies("key")="selfreg" then
    if Request.cookies("reglevel")=3 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=3) order by newsid DESC"
    end if
    if Request.cookies("reglevel")=2 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=2) order by newsid DESC"
    end if
    if Request.cookies("reglevel")=1 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=1) order by newsid DESC"
    end if
end if
else
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1) order by newsid DESC"
end if
rs3.Open rs3.Source,conn,1,1
while not rs3.EOF
if showyear=1 then
newsurl="ReadNews.asp?NewsID=" & rs3("NewsID")
datetime="<font class=middle>(" & year(rs3("UpdateTime"))  &"年"& Month(rs3("UpdateTime"))  &"月"& Day(rs3("UpdateTime")) &"日)</font>"
else
newsurl="ReadNews.asp?NewsID=" & rs3("NewsID")
datetime="<font class=middle>("& Month(rs3("UpdateTime"))  &"月"& Day(rs3("UpdateTime")) &"日)</font>"
end if
if rs3("picnews")=1 then
img="<img src='IMAGES/IMG.gif' border='0'>"
else
img=""
end if
title=trim(rs3("title"))
title=replace(title,"<br>","")
%>
                  <tr>
                    <td colspan="2">
                      <div align="center">
                        <%if mode="2" then%>
                        <table width="95%" border="0" cellpadding="0" cellspacing="0" background="img/line1.gif">
                          <tr>
                            <td width="65%" height="20" >  <img src="img/arrow02.gif" width="8" height="8"><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank"></a><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank"> <%=img%> <<%=rs3("titletype")%>><font color="<%=rs3("titlecolor")%>">
                              <%if showtime="1" then%>
                              <%if len(title)>24 then%>
                              <%=left(title,24)%>
                              <%else%>
                              <%=title%>
                              <%end if%>
                              <%else%>
                              <%if len(title)>24 then%>
                              <%=left(title,24)%>
                              <%else%>
                              <%=title%>
                              <%end if%>
                              <%end if%>
                            </font></<%=rs3("titletype")%>></a> </td>
                            <td width="15%" align="right">
                              <div align="center">
                                <%if showauthor="1" then%>
                                <%=rs3("Author")%>
                                <%end if%>
                            </div></td>
                            <td width="20%" align="left">
                              <div align="center">
                                <%if showtime="1" then%>
                                <%=datetime%>
                                <%end if%></div></td>
                          </tr>
                        </table>
                        <%else%>
                        <%if mode="3" then%>
                        <table width="95%" border="0" cellpadding="3" cellspacing="0">
                          <tr bgcolor="#EFEFEF">
                            <td width="55%">  <img src="IMAGES/go.gif" width="8" height="10"><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank"></a><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank"> <strong><%=img%>
                                    <%end if%>
<<%=rs3("titletype")%>><font color="<%=rs3("titlecolor")%>">
                          <%if showtime="1" then%>
                          <%if len(title)>20 then%>
                          <%=left(title,20)%>
                          <%else%>
                          <%=title%>
                          <%end if%>
                          <%else%>
                          <%if len(title)>24 then%>
                          <%=left(title,24)%>
                          <%else%>
                          <%=title%>
                          <%end if%>
                          <%end if%>
                        </font></strong></<%=rs3("titletype")%>></a> </td>
                            <td width="29%" align="right">
                              <%if showtime="1" then%>
                              <%=datetime%>
                              <%end if%></td>
                            <td width="16%" align="right">
                              <%if year(rs3("updatetime"))=year(date()) and month(rs3("updatetime"))=month(date()) and day(rs3("updatetime"))=day(date()) then%>
                              <img src="images/new.gif">
                              <%end if%>
                              <%if rs3("goodnews")="1" then%>
                              <img src="images/g.gif" >
                              <%end if%>
                            </td>
                          </tr>
                          <tr>
                            <td width="55%">   [简介]: <%=left(nohtml(rs3("Content")),80)%>...</td>
                            <td width="45%" colspan="2">[网址]
                                <%
                               strText = (rs3("Content"))
                               posleft=Instr(strText,"<A")
                               posright=Instr(strText,"/A>")
                               posp=Instr(strText,"<P><A")+3
                               posp2=Instr(strText,"A></P>")
                               %>
                                <% if posp<>0 and posp2<>0 then %>
                                <%=mid(rs3("Content"),posp,posp2)%>
                                <% else %>
                                <% if posleft=1 then %>
                                <%=left(rs3("Content"),posright)%>
                                <% else %>
                                <%=right(rs3("Content"),(posright+3)-posleft)%>
                                <% end if %>
                                <% end if %>
                            </td>
                          </tr>
                        </table>
                    </div></td>
                  </tr>
                  <%end if%>
                  <%

rs3.MoveNext
wend
%>
                </table>
                <%
end if
next
'rs3.close
'set rs3=nothing
else
Response.Write "<table width=98% border=0 height=25><tr><td>暂无大类</td></tr></table>"
end if
%>
                <%else%>
                <%
  if rseof=1 then
for i=1 to abcount
BigClassID=ArrayBigClassID(i)
BigClassName=ArrayBigClassName(i)
BigClassview=ArrayBigClassview(i)
if ArrayBigClassView(i)=1 then
%>
                <table border="0" cellpadding="3" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="100%" id="AutoNumber5">
                  <tr>
                    <td height="25"><span class="6"> <img src="img/type02.gif" width="9" height="9" align="absmiddle">  </span><font class=m_tittle><%=BigClassName%></font></td>
                  </tr>
                  <%
set rs3=server.CreateObject("ADODB.RecordSet")
if uselevel=1 then
if Request.cookies("key")="super" or Request.cookies("key")="typemaster" or Request.cookies("key")="bigmaster" or Request.cookies("key")="smallmaster" or Request.cookies("key")="check" then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1) order by newsid DESC"
end if
if Request.cookies("key")="" then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel=0) order by newsid DESC"
end if
if Request.cookies("key")="selfreg" then
    if Request.cookies("reglevel")=3 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=3) order by newsid DESC"
    end if
    if Request.cookies("reglevel")=2 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=2) order by newsid DESC"
    end if
    if Request.cookies("reglevel")=1 then
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1 and newslevel<=1) order by newsid DESC"
    end if
end if
else
rs3.Source="select top " & top_news & " * from News where (BigClassid=" & BigClassid &" and checkked=1) order by newsid DESC"
end if
rs3.Open rs3.Source,conn,1,1
while not rs3.EOF
if showyear=1 then
newsurl="ReadNews.asp?NewsID=" & rs3("NewsID")
datetime="<font class=middle>(" & year(rs3("UpdateTime"))  &"年"& Month(rs3("UpdateTime"))  &"月"& Day(rs3("UpdateTime")) &"日)</font>"
else
newsurl="ReadNews.asp?NewsID=" & rs3("NewsID")
datetime="<font class=middle>("& Month(rs3("UpdateTime"))  &"月"& Day(rs3("UpdateTime")) &"日)</font>"
end if
if rs3("picnews")=1 then
img="<img src=""IMAGES/IMG.gif"">"
else
img=""
end if
title=trim(rs3("title"))
title=replace(title,"<br>","")
%>
                  <tr>
                    <td height=18>
                      <div align="center">
                        <%if mode="4" then%>
                        <table width="95%" border="0" cellpadding="3" cellspacing="0">
                          <tr bgcolor="#EFEFEF">
                            <td width="65%" bgcolor="#EFEFEF"> <img src="IMAGES/004.gif" width="8" height="10"><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank"> <font color="<%=rs3("titlecolor")%>"><strong>
                              <%if len(title)>20 then%>
                              <%=left(title,20)%>...
                              <%else%>
                              <%=title%>
                              <%end if%>
                            </strong> </font></a></td>
                            <td width="22%" align="right" bgcolor="#EFEFEF">
                              <%if showtime="1" then%>
                              <%=datetime%>
                              <%end if%>
                              <%if showclick="1" then%>
                              <font color=#666666>[<%=rs3("click")%>]</font>
                              <%end if%>
  </td>
                            <td width="13%" align="center">
                              <%if year(rs3("updatetime"))=year(date()) and month(rs3("updatetime"))=month(date()) and day(rs3("updatetime"))=day(date()) then%>
                              <img src="images/new.gif">
                              <%end if%>
                              <%if rs3("goodnews")="1" then%>
                              <img src="images/g.gif" >
                              <%end if%>
                            </td>
                          </tr>
                          <tr>
                            <td colspan="3">   [软件简介]: <%=left(nohtml(rs3("Content")),100)%>... </td>
                          </tr>
                        </table>
                        <%else%>
                        <%if mode="1" then%>
                        <table width="95%" border="0" cellpadding="3" cellspacing="0">
                          <tr bgcolor="#EFEFEF">
                            <td colspan="2">  <img src="IMAGES/IMG.gif" width="9" height="9"><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank">
                              <%end if%>
                              <font color="<%=rs3("titlecolor")%>"><strong>
                              <%if len(title)>10 then%>
                              <%=left(title,10)%>...
                              <%else%>
                              <%=title%>
                              <%end if%>
                            </strong> </font></a></td>
                            <td width="22%" align="right" bgcolor="#EFEFEF">
                              <%if showtime="1" then%>
                              <%=datetime%>
                              <%end if%>
                              <%if showclick="1" then%>
                              <font color=#666666>[<%=rs3("click")%>]</font>
                              <%end if%>
  </td>
                            <td width="13%" align="center">
                              <%if year(rs3("updatetime"))=year(date()) and month(rs3("updatetime"))=month(date()) and day(rs3("updatetime"))=day(date()) then%>
                              <img src="images/new.gif">
                              <%end if%>
                              <%if rs3("goodnews")="1" then%>
                              <img src="images/g.gif" >
                              <%end if%>
                            </td>
                          </tr>
                          <tr>
                            <td width="16%"><a class=middle href="ReadNews.asp?NewsID=<%=rs3("NewsID")%>" target=_blank title="<%=rs3("title")%>">
                              <%if   rs3("picname")=("")   then%>
                              <img  src="IMAGES/Image18.gif" width="65" height="65" border=0 align="left">
                              <%else%>
                              <img  src="uploadfile/<%=rs3("picname")%>" width="65" height="65" border=0 align="left">
                              <%end if%>
                            </a> </td>
                            <td colspan="3" valign="top"><%=left(nohtml(rs3("Content")),150)%>... </td>
                          </tr>
                        </table>
                        <%end if%>
                      </div>
                      <div align="center"> </div></td>
                  </tr>
                  <%

rs3.MoveNext
wend
%>
                  <tr>
                    <td width=100% align=right height=18><a class=class href='BigClass.asp?typeid=<%=typeid%>&BigClassid=<%=BigClassid%>'><img src="images/more.gif" border="0" alt="更多<%=BigClassName%>"></a>  </td>
                  </tr>
                </table>
                <%
end if
next
'rs3.close
'set rs3=nothing
else
Response.Write "<table width=98% border=0 height=25><tr><td>暂无大类</td></tr></table>"
end if
%>
                <%end if%>
                <%if mode=2 then%>
                <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" width="100%" id="AutoNumber5">
                  <tr>
                    <td height="30" background="img/type_bg.gif" class="7">  <img src=img/type03.gif width="9" height="9">  本月最新</td>
                  </tr>
                  <%  dim ii
    ii = 0
    if uselevel=1 then
if Request.cookies("key")="" then
rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" and newslevel=0 order by click DESC,newsid desc"   '选择本月
end if
if Request.cookies("key")="selfreg" then
    if Request.cookies("reglevel")=3 then
    rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" and newslevel<=3 order by click DESC,newsid desc"   '选择本月
    end if
    if Request.cookies("reglevel")=2 then
    rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" and newslevel<=2 order by click DESC,newsid desc"   '选择本月
    end if
    if Request.cookies("reglevel")=1 then
    rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" and newslevel<=1 order by click DESC,newsid desc"   '选择本月
    end if
end if
if Request.cookies("key")="super" or Request.cookies("key")="typemaster" or Request.cookies("key")="bigmaster" or Request.cookies("key")="smallmaster" or Request.cookies("key")="check" then
rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" order by click DESC,newsid desc"   '选择本月
end if
else
rs.Source="select top " & top_txt & " * from News where year(updatetime)=year(now()) and month(updatetime)=month(now()) and checkked=1 and typeid="&typeid&" order by click DESC,newsid desc"   '选择本月
end if
rs.Open rs.Source,conn,1,1
    if rs.bof and rs.eof then
        response.write "<td align=center>本月无更新</td>"
    else
    do while not rs.eof
title=trim(rs("title"))
title=replace(title,"<br>","")
%>
                  <tr>
                    <td height="24">
                      <div align="center">
                        <table width="95%" border="0" cellpadding="3" cellspacing="0" background="img/line1.gif">
                          <tr>
                            <td height="20">  <img src="img/arrow03.gif" width="8" height="8"><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank"></a><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank"></a><a class=middle href="<%=newsurl%>" title="<%=title%>" target="_blank"></a><a class=middle href="ReadNews.asp?NewsID=<%=rs("NewsID")%>" title="<%=title%>" target="_blank">
                              <%if mode="2" then%>
                              <%if rs("picnews")=1 then%>
                              <img src='IMAGES/IMG.gif' border='0'>
                              <%end if%>
                              <%end if%>
                              <font color="<%=rs("titlecolor")%>"><%=gottopic(title,50)%></font></a><font color="#666666">&nbsp; </font> </td>
                            <td width="5%" align="center"><font color="#666666"><%=rs("click")%></font> </td>
                            <td width="8%" align="left"><div align="center"></div></td>
                          </tr>
                        </table>
                        <font color="#666666"> </font> </div></td>
                  </tr>
                  <%  ii = ii + 1
    if ii>50 then exit do
    rs.movenext     
    loop
    end if  
    rs.close   
    set rs=nothing
%>
                </table>
                <br>
                <%end if%>
                <%end if%>
              </td>
            </tr>
        </table></td>
      </tr>
    </table></td>
  </tr>
</table>
<!--#include file=include/bottom.asp -->
#4
2008-07-15 15:31
在windwos2003系统中一点问题没有,在2000系统下出现上述问题
#5
madpbpl2008-07-15 17:26
试试修改文件夹权限
#6
2008-07-16 08:34
文件夹权限也修改了,没什么用处!!
1