关于一个数据库显示的问题 - ASP技术论坛

问题点数：0 回复次数：0

关于一个数据库显示的问题

我想从数据库中读取图片的路径并且显示图片，每行显示两个，并且要分页显示，可是总是出错！各位给瞧瞧！
代码如下，想看看整个站点的请去我的ftp空间下载 ip: 222.43.120.111 密码：131452057 就在wwwroot里面谢谢！

<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>

<%set conn=server.createobject("ADODB.CONNECTION")
path=server.MapPath("database\lovesnow.mdb")
conn.open "provider=microsoft.jet.oledb.4.0; data source="& path &""%>
<% set rs=server.CreateObject("adodb.recordset")
sql="select * from logo order by logo_id asc"
rs.open sql,conn,1,1
rs.PageSize=2%>
<html>
<head>
<title>东方翻译工作室</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
body,td,th {
font-family: 宋体;
font-size: 12px;
}
#banner1 {
background-image: url(images/index_02.gif);
height: 26px;
width: 610px;
}
#banner2 {
background-image: url(images/index_03.jpg);
height: 33px;
width: 610px;
}
#banner3 {
background-image: url(images/index_04.jpg);
height: 32px;
}
#banner4 {
background-image: url(images/index_05.gif);
height: 21px;
width: 1000px;
}
#banner5 {
background-image: url(images/index_09.jpg);
height: 34px;
width: 819px;
}
#banner6 {
background-image: url(images/index_10.jpg);
height: 30px;
}
#banner7 {
background-image: url(images/index_11.gif);
height: 33px;
}
#banner8 {
background-image: url(images/index_12.jpg);
height: 28px;
}
#banner9 {
background-image: url(images/index_13.jpg);
height: 33px;
}
#bg_line {
background-image: url(images/index_14.gif);
background-repeat: no-repeat;
background-position: top;
height: 86px;
width: 8px;
}
.line {
border-bottom-width: 1px;
border-bottom-style: solid;
border-bottom-color: #EBEBEB;
}
.hui12 {
color: #666666;
font-family: "宋体";
font-size: 12px;
text-decoration: none;
line-height: 18px;
}
#bg_quan {
background-image: url(images/index_21.jpg);
width: 10px;
}
.hui25 {
font-family: "方正细倩简体";
font-size: 24px;
color: #535353;
text-decoration: none;
font-weight: bold;
}
.english {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
color: #999999;
text-decoration: none;
}
#bg_08 {
background-image: url(images/index_08.gif);
background-repeat: no-repeat;
background-position: top;
height: 244px;
width: 25px;
}
.white18 {
font-family: "方正细倩简体";
font-size: 18px;
color: #FFFFFF;
text-decoration: none;
}
.white8 {
font-size: 8px;
color: #FFFFFF;
text-decoration: none;
font-family: Geneva, Arial, Helvetica, sans-serif;
}
a.white:link {
font-family: "宋体";
font-size: 12px;
color: #FFFFFF;
text-decoration: none;
}
a.white:visited {
font-family: "宋体";
font-size: 12px;
color: #FFFFFF;
text-decoration: none;
}
a.white:hover {
font-family: "宋体";
font-size: 12px;
color: #FFFF00;
text-decoration: underline;
}
#bg_line2 {
background-image: url(images/index_13.gif);
background-repeat: no-repeat;
background-position: center bottom;
height: 12px;
}
#bg_news {
background-image: url(images/index_32.gif);
height: 41px;
}
#bg_news2 {
background-image: url(images/index_35.gif);
height: 28px;
}
#bg_lianjie {
background-image: url(images/index_37.gif);
height: 35px;
}
.hui14 {
font-family: "宋体";
font-size: 14px;
color: #666666;
line-height: 22px;
}
#bg_ico {
background-image: url(images/ico.gif);
background-repeat: no-repeat;
background-position: right bottom;
}
.line2 {
border-top-width: 1px;
border-top-style: solid;
border-top-color: #CECECE;
}
.hei12 {
font-family: "宋体";
font-size: 12px;
font-style: italic;
text-decoration: none;
line-height: 18px;
}
.white12 {
font-family: "宋体";
font-size: 12px;
line-height: 18px;
color: #FFFFFF;
text-decoration: none;
}

-->
</style>
</head>
<body style="text-align:center" bgcolor="#FFFFFF" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<table width="1000" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="390" rowspan="3"><img src="images/index_01.jpg" width="390" height="91" alt=""></td>
<td id="banner1"> </td>
</tr>
<tr>
<td id="banner2"></td>
</tr>
<tr>
<td id="banner3"></td>
</tr>
<tr>
<td height="22" colspan="2" id="banner4"></td>
</tr>
</table>
<table width="1000" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="156" valign="bottom" background="images/index_07.gif"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td><p> </p>
<p> </p></td>
</tr>
<tr>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td width="29%" align="right"><img src="images/tubiao1.gif" width="12" height="12"></td>
<td width="11%"> </td>
<td width="64%" height="19" class="white"><a href="/index.html" class="white">网站首页</a></td>
</tr>
<tr>
<td colspan="3" align="center" id="bg_line2"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td width="29%" align="right"><img src="images/tubiao1.gif" width="12" height="12"></td>
<td width="11%"> </td>
<td width="64%" height="19" class="white"><a href="/tdjj.asp" class="white">团队简介</a></td>
</tr>
<tr>
<td colspan="3" align="center" id="bg_line2"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td width="29%" align="right"><img src="images/tubiao1.gif" width="12" height="12"></td>
<td width="11%"> </td>
<td width="64%" height="19" class="white"><a href="/ywfw.asp" class="white">业务范围</a></td>
</tr>
<tr>
<td colspan="3" align="center" id="bg_line2"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td width="29%" align="right"><img src="images/tubiao1.gif" width="12" height="12"></td>
<td width="11%"> </td>
<td width="64%" height="19" class="white"><a href="/fyyz.asp" class="white">翻译语种</a></td>
</tr>
<tr>
<td colspan="3" align="center" id="bg_line2"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td width="29%" align="right"><img src="images/tubiao1.gif" width="12" height="12"></td>
<td width="11%"> </td>
<td width="64%" height="19" class="white"><a href="/fybj.asp" class="white">翻译报价</a></td>
</tr>
<tr>
<td colspan="3" align="center" id="bg_line2"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td width="29%" align="right"><img src="images/tubiao1.gif" width="12" height="12"></td>
<td width="11%"> </td>
<td width="64%" height="19" class="white"><a href="/zlkz.asp" class="white">质量控制</a></td>
</tr>
<tr>
<td colspan="3" align="center" id="bg_line2"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td width="29%" align="right"><img src="images/tubiao1.gif" width="12" height="12"></td>
<td width="11%"> </td>
<td width="64%" height="19" class="white"><a href="/tdke.asp" class="white">团队客户</a></td>
</tr>
<tr>
<td colspan="3" align="center" id="bg_line2"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td width="29%" align="right"><img src="images/tubiao1.gif" width="12" height="12"></td>
<td width="11%"> </td>
<td width="64%" height="19" class="white"><a href="/lianxi.asp" class="white">联系我们</a></td>
</tr>
<tr>
<td colspan="3" align="center" id="bg_line2"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr valign="top">
<td width="29%" align="right"><img src="images/tubiao1.gif" width="12" height="12"></td>
<td width="11%"> </td>
<td width="64%" height="19" class="white"><a href="/book/index.asp" class="white">客户留言</a></td>
</tr>
<tr>
<td colspan="3" align="center" id="bg_line2"></td>
</tr>
</table>
<table width="100%" height="25" border="0" cellpadding="0" cellspacing="0">
<tr>
<td> </td>
</tr>
</table>
<table width="146" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td id="bg_news"></td>
</tr>
<tr>
<td height="166" align="center" valign="bottom" background="images/index_33.gif"><marquee direction="up" width="145" height="145" scrolldelay="187" align="absmiddle" onMouseOver="javascript:this.stop();" onMouseOut="javascript:this.start();">
<%
dim j
for j=1 to i-1%>
<a href="news.asp?news_id=<%=b(j)%>"><%=a(j)%></a> <br>
<%next%>
</marquee></td>
</tr>
<tr>
<td id="bg_news2"> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="8"></td>
</tr>
</table>
<table width="146" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td id="bg_lianjie"></td>
</tr>
<tr>
<td height="166" background="images/index_33.gif"><table width="100%" border="0">
<tr>
<td align="center"><img src="/images/weihai.gif" width="125" height="32"></td>
</tr>
<tr>
<td align="center"><img src="/images/weihai.gif" width="125" height="32"></td>
</tr>
<tr>
<td align="center"><img src="/images/weihai.gif" width="125" height="32"></td>
</tr>
<tr>
<td align="center"><img src="/images/weihai.gif" width="125" height="32"></td>
</tr>
</table></td>
</tr>
<tr>
<td id="bg_news2"> </td>
</tr>
</table></td>
</tr>
</table></td>
<td valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td id="bg_08"></td>
<td valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td id="banner5"></td>
</tr>
<tr>
<td id="banner6"> </td>
</tr>
<tr>
<td id="banner7"></td>
</tr>
<tr>
<td id="banner8"></td>
</tr>
<tr>
<td id="banner9"></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td rowspan="2" id="bg_line"></td>
<td height="23" align="center" class="line"><table width="30%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="19%" align="right"><img src="images/tubiao2.gif" width="12" height="12"></td>
<td width="81%"> <span class="hui12"><strong>您的位置是</strong>
>> 团队客户</span></td>
</tr>
</table></td>
</tr>
<tr>
<td height="63"><table width="98%" border="0" align="right" cellpadding="0" cellspacing="0">
<tr>
<td width="6"><img src="images/index_17.gif" width="6" height="43"></td>
<td width="165" align="center"><span class="hui25">团队客户</span><span class="english">
</span></td>
<td width="437" background="images/index_19.gif"> </td>
<td width="10" id="bg_quan"></td>
<td width="177"> </td>
</tr>
</table></td>
</tr>
</table>
<table width="90%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="3%"> </td>
<td width="97%" align="center" id="bg_ico">
<table width="85%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td align="center" valign="top"><span class="hui12">　</span>
<table width="100%" border="0">
<tr align="center">
<td colspan="4">
<div align="center">　　　　　
<%if rs.eof and rs.bof then%>
　　　 <%="现在还没有记录"%> </div></td>
</tr>
<%else
pagecount=rs.PageCount
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then
page=1
end if
rs.AbsolutePage=page
for i=1 to rs.pagesize
if rs.eof then
exit for
end if
%>

<tr>
<a href="http://<%=rs("logo_link")%>" & "<%=rs("logo_link")%>"><img src="<%=rs("logo_path")%>" width="220" height="66" border="0"></a>
<%rs.movenext%>
<a href="http://<%=rs("logo_link")%>" & "<%=rs("logo_link")%>"><img src="<%=rs("logo_path")%>" width="220" height="66" border="0"></a>
<br>

</tr><%rs.movenext%>
<%rs.movenext%>
<%next
end if%>
<tr>
<td colspan="2" rowspan="2"><div align="center"> 转到第
<select name="sel_page" onChange="javascript:location=this.options[this.selectedIndex].value;">
<%
for i = 1 to rs.PageCount
if i = page then%>
<option value="?page=<%=i%>" selected><%=i%></option>
<%else%>
<option value="?page=<%=i%>"><%=i%></option>
<%
end if
next
%>
</select>
页 </div></td>
<td align="center"> </td>
</tr>
<tr>
<td> </td>
</tr>
</table>
<br>
<br>
<span class="hui12">　<br>
<br>
</span></td>
</tr>
</table>
<table width="77%" border="0" cellpadding="0" cellspacing="0" class="line2">
<tr>
<td height="200" valign="bottom" class="hui12"><table width="60%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td class="english">　　　　　　　联系人：韩经理夏经理 <br>
　　　　　　　联系电话：15966879660 15954207933<br>
　　　　　　　电　　话：+86-532-84865603<br>
　　　　　　　传　　真：+86-532-84865603<br>
</td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="30" valign="top">
<p> </p>
<p> </p>
<p> </p>

</td>
</tr>
<tr>
<td height="38" align="center" bgcolor="#434343" class="white12"> 版权所有　www.east-translation.com</td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>

[此贴子已经被作者于2007-3-20 17:07:53编辑过]

搜索更多相关主题的帖子: database　blank　include　target　数据库　