| 网站首页 | 业界新闻 | 小组 | 威客 | 人才 | 下载频道 | 博客 | 代码贴 | 在线编程 | 编程论坛
欢迎加入我们,一同切磋技术
用户名:   
 
密 码:  
共有 983 人关注过本帖
标题:[求助]asp读取不了数据库字段
只看楼主 加入收藏
foreverone1
Rank: 1
等 级:新手上路
帖 子:2
专家分:0
注 册:2007-5-21
收藏
 问题点数:0 回复次数:2 
[求助]asp读取不了数据库字段

<!--#include file="conn.asp"-->
<!--#include file="webconfig.asp"-->
<%dim nclassid
nclassid=request.querystring("nid")%>
<html>
<head>
<title>商品分类</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<STYLE type=text/css>
.pad {
PADDING-LEFT: 2px
}
</style>
<style>
td{font-size:9pt;line-height:120%;color:#353535}
body{font-size:9pt;line-height:120%}

a:link { color: #000000; text-decoration: none }
a:visited { color: #000000; text-decoration: none }
a:active { color: #000000; text-decoration: none }
a:hover { color: #336699; text-decoration: none; position: relative; right: 0px; top: 1px }
</style>
<link href="images/css.css" rel="stylesheet" type="text/css">
</head>
<body>
<!--#include file="webtop.asp"--> <table width="770" border="0" cellspacing="0" cellpadding="0" align="center" bordercolor="#6699CC">
<tr> <td valign="top" WIDTH="21%" BGCOLOR="#AD8585"> <!--#include file="indexuserinfo.asp"--><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr>
<td height="6"></td></tr> <tr> <td valign="top"> <div align="center"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr> <td> <div align="center"><a href=<%=gg3url%> target=_blank><img src=<%=gg3%> border="0"></a></div></td></tr>
<tr> <td height="6"></td></tr> <tr> <td> <div align="center"><a href=<%=gg4url%> target=_blank><img src=<%=gg4%> border="0"></a></div></td></tr>
<tr> <td height="6"><TABLE CELLSPACING=0 CELLPADDING=0 WIDTH=100% BGCOLOR="#993300" HEIGHT="20">
<TR> <TD WIDTH=6>&nbsp;</TD><TD WIDTH=17><IMG SRC="images/index7.gif" WIDTH="10" HEIGHT="11"></TD><TD CLASS=hg12 VALIGN=bottom>&nbsp;<B><FONT COLOR="#FFFFFF">热点商品</FONT></B></TD><TD WIDTH=5>&nbsp;</TD></TR>
</TABLE></td></tr> </table><TABLE WIDTH="100%" BORDER="0" ALIGN="center" CELLPADDING="0" CELLSPACING="1">
<%set rs=server.CreateObject("adodb.recordset")
rs.open "select top 10 bookid,bookname,liulancount from shop_books order by liulancount desc",conn,1,1
if rs.eof and rs.bof then
response.write "对不起,请您先到程序后台添加商品。"
response.End()
else
dim i
i=1
do while not rs.eof
%> <TR> <TD WIDTH="17"> <DIV ALIGN="center"><%=i%></DIV></TD><TD WIDTH="138" CLASS=pad>
<%response.write "<a href=book.asp?id="&rs("bookid")&" title=此商品已被浏览过"&rs("liulancount")&"次>"&trim(rs("bookname"))&"</a>"%>
</TD></TR> <%if i>9 then exit do
rs.movenext
i=i+1
loop
rs.close
set rs=nothing
end if%> <TR> <TD COLSPAN="2"> <DIV ALIGN="right"><A HREF="bookorder.asp">更多的关注排行&gt;&gt;</A></DIV></TD></TR>
</TABLE></div></td></tr> </table><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr> <td height="5"></td></tr> <tr> <td height="5" colspan="2"></td></tr> <tr>
<td height="72"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr> <td> <div align="center"><a href=<%=gg1url%> target="_blank"><img src=<%=gg1%> border="0"></a></div></td></tr>
<tr> <td height="6"></td></tr> <tr> <td> <div align="center"><a href=<%=gg2url%> target="_blank"><img src=<%=gg2%> border="0"></a></div></td></tr>
<tr> <td height="6"></td></tr> </table></td></tr> <tr> <td height="57" valign="top">
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr> <td height="5" colspan="2"></td></tr> <tr> <td height="1" colspan="2"><TABLE CELLSPACING=0 CELLPADDING=0 WIDTH=100% BGCOLOR="#996600" HEIGHT="20">
<TR> <TD WIDTH=6>&nbsp;</TD><TD WIDTH=17><IMG SRC="images/index7.gif" WIDTH="10" HEIGHT="11"></TD><TD CLASS=hg12 VALIGN=bottom>&nbsp;<B><FONT COLOR="#FFFFFF">热销商品</FONT></B></TD><TD WIDTH=5>&nbsp;</TD></TR>
</TABLE></td></tr> <%set rs=server.CreateObject("adodb.recordset")
rs.open "select top 10 bookid,bookname,chengjiaocount from shop_books order by chengjiaocount desc",conn,1,1
if rs.eof and rs.bof then
response.write "还没有商品"
response.End()
else
i=1
do while not rs.eof
%> <tr> <td width="17"> <div align="center"><%=i%></div></td><td width="138" class=pad>
<%response.write "<a href=book.asp?id="&rs("bookid")&" title=此商品已成功销售"&rs("chengjiaocount")&"次>"&trim(rs("bookname"))&"</a>"%>
</td></tr> <%if i>9 then exit do
rs.movenext
i=i+1
loop
rs.close
set rs=nothing
end if%> <tr> <td colspan="2"> <div align="right"><a href="bookorder.asp">更多的销售排行&gt;&gt;</a></div></td></tr>
</table></td></tr> </table></td><td width="581" valign="top" BGCOLOR="#F2E6E7">
<table width="98%" border="0" cellspacing="0" cellpadding="0" bordercolor="#6699CC" align="center">
<tr> <td> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr>
<td rowspan="2"> <table width="100%" border="0" cellspacing="0" cellpadding="0" class="12v">
<tr> <td class="12v" > <table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" id="AutoNumber3" height="0" width="100%">
<tr> <td> <%'开始分页
Const MaxPerPage=8
dim totalPut
dim CurrentPage
dim TotalPages
dim j
dim sql
if Not isempty(request("page")) then
currentPage=Cint(request("page"))
else
currentPage=1
end if
if nclassid="" then
set rs=server.CreateObject("adodb.recordset")
rs.open "select top 20 qch,jj,rq,bookid,bookname,bookzz,bookchuban,shichangjia,huiyuanjia,dazhe,bookdate,bookpic from shop_books order by adddate desc",conn,1,1
else
set rs=server.CreateObject("adodb.recordset")
rs.open "select bookid,bookname,bookzz,bookchuban,shichangjia,huiyuanjia,dazhe,bookdate,bookpic from shop_books where nclassid="&nclassid&" order by adddate desc",conn,1,1
end if

if err.number<>0 then
response.write "数据库中无数据"
end if

if rs.eof And rs.bof then
Response.Write "<p align='center' class='contents'> 对不起,此分类暂时还没有商品!</p>"
else
totalPut=rs.recordcount

if currentpage<1 then
currentpage=1
end if

if (currentpage-1)*MaxPerPage>totalput then
if (totalPut mod MaxPerPage)=0 then
currentpage= totalPut \ MaxPerPage
else
currentpage= totalPut \ MaxPerPage + 1
end if
end if

if currentPage=1 then
showContent
showpage totalput,MaxPerPage,"class.asp"
else
if (currentPage-1)*MaxPerPage<totalPut then
rs.move (currentPage-1)*MaxPerPage
dim bookmark
bookmark=rs.bookmark
showContent
showpage totalput,MaxPerPage,"class.asp"
else
currentPage=1
showContent
showpage totalput,MaxPerPage,"class.asp"
end if
end if
end if

sub showContent
dim i
i=0

%> <table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr> <td> <%if nclassid="" then
response.write "<img src=guanggao/newbooks.gif width=589 height=46 alt=商品分类TOP20>"
else
response.write "<img src=guanggao/newbooks.gif width=589 height=46 >"
end if%> <TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="0"><TR><TD>&nbsp;</TD></TR></TABLE></td></tr>
<tr> <td> <%
do while not rs.eof%> <table width="96%" border="0" align="center" cellpadding="3" cellspacing="0">
<tr> <td height="5" colspan="2" valign="top"></td></tr> <tr> <td width="18%" valign="top">
<div align="center"> <%
response.Write "<a href=book.asp?id="&rs("bookid")&">"
if trim(rs("bookpic"))<>"" then
response.Write "<img src="&trim(rs("bookpic"))&" width=130 border=0 ></a>"
else
response.Write "<img src=images/emptybook.gif width=130 border=0></a>"
end if%></div></td><td width="82%"> <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr> <td colspan="3"><a href=book.asp?id=<%=rs("bookid")%>><font color="#FF0000"><%=trim(rs("bookname"))%></font></a></td></tr>
<tr> <td colspan="3"> <%=trim(rs("bookzz"))%></td></tr> <tr> <td colspan="3">
<%=trim(rs("bookchuban"))%></td></tr> <tr> <td colspan="3"> <%=trim(rs("bookdate"))%></td></tr>
<tr> <td width="37%">市场价:<%=formatnumber(rs("shichangjia"),2)&"元"%></td><td width="35%">会员价:<font color=red><%=formatnumber(rs("huiyuanjia"),2)&"元"%></font></td><td width="28%">折&nbsp;&nbsp;扣:<%=formatnumber(rs("dazhe")*10,2)&"折"%></td></tr>
<tr> <td height="24" colspan="3"> <div align="center"> <%response.write "<a href=# onClick=""javascript:window.open('shopping.asp?id="&rs("bookid")&"','','width=632,height=388,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;""><img src=images/cart.gif width=60 height=19 align=absmiddle border=0></a> "
response.write "&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href=# onClick=""javascript:window.open('shoucang.asp?id="&rs("bookid")&"&action=add','','width=632,height=388,toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes');return false;""><img src=images/favorite.gif width=60 height=19 align=absmiddle border=0></a> "%>
</div></td></tr> </table></td></tr> </table><%
i=i+1
if i>=MaxPerPage then Exit Do
rs.movenext
loop
rs.close
set rs=nothing
%> </td></tr> </table><%
End Sub

Function showpage(totalnumber,maxperpage,filename)
Dim n

If totalnumber Mod maxperpage=0 Then
n= totalnumber \ maxperpage
Else
n= totalnumber \ maxperpage+1
End If

Response.Write "<form method=Post action="&filename&"?nid="&nclassid&">"
Response.Write "<p align='center' class='contents'> "
If CurrentPage<2 Then
Response.Write "<font class='contents'>首页 上一页</font> "
Else
Response.Write "<a href="&filename&"?page=1&nid="&nclassid&" class='contents'>首页</a> "
Response.Write "<a href="&filename&"?page="&CurrentPage-1&"&nid="&nclassid&" class='contents'>上一页</a> "
End If

If n-currentpage<1 Then
Response.Write "<font class='contents'>下一页 尾页</font>"
Else
Response.Write "<a href="&filename&"?page="&(CurrentPage+1)&"&nid="&nclassid&" class='contents'>"
Response.Write "下一页</a> <a href="&filename&"?page="&n&"&nid="&nclassid&" class='contents'>尾页</a>"
End If
Response.Write "<font class='contents'> 页次:</font><font class='contents'>"&CurrentPage&"</font><font class='contents'>/"&n&"页</font> "
Response.Write "<font class='contents'> 共有"&totalnumber&"种商品 "
Response.Write "<font class='contents'>转到:</font><input type='text' name='page' size=2 maxlength=10 class=smallInput value="&currentpage&">"
Response.Write "&nbsp;<input type='submit' class='contents' value='GO' name='cndok'></form>"
End Function
%> </td></tr> </table></td></tr> </table></td></tr> </table></td></tr>
</table></td></tr> </table><!--#include file="service.asp"-->
</body>
</html>
读取不了数据库中的图片,数据库是ACCESS,是不是这段代码有问题 if trim(rs("bookpic"))<>"" then
response.Write "<img src="&trim(rs("bookpic"))&" width=130 border=0 ></a>"
else
response.Write "<img src=images/emptybook.gif width=130 border=0></a>"
end if%>还是其他地方有问题,请高手指点!!谢谢!~

搜索更多相关主题的帖子: 数据库 字段 asp 
2007-05-21 20:27
谁与争疯
Rank: 16Rank: 16Rank: 16Rank: 16
来 自:海南省
等 级:版主
威 望:191
帖 子:15071
专家分:17513
注 册:2007-4-22
收藏
得分:0 
读取不了数据库中的图片,数据库是ACCESS,是不是这段代码有问题 if trim(rs("bookpic"))<>"" then
response.Write "<img src="&trim(rs("bookpic"))&" width=130 border=0 ></a>"
else
response.Write "<img src=images/emptybook.gif width=130 border=0></a>"
end if%>还是其他地方有问题,请高手指点!!谢谢!~


这一段我看不出有什么样的问题、能否将执行后显示的错误信息发在这儿?

论坛是我家灌水靠大家
2007-05-21 21:41
foreverone1
Rank: 1
等 级:新手上路
帖 子:2
专家分:0
注 册:2007-5-21
收藏
得分:0 
没有错误信息,就是显示不了图片,可以读取bookname,bookchuban,bookdate都没问题,就是读取不了图片
2007-05-23 09:16
快速回复:[求助]asp读取不了数据库字段
数据加载中...
 
   



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

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