请大家帮帮忙!!
首页供求信息里为什么链接不到指定的页面?
<%dim w(25)
w(1)="剁辣椒块"
w(2)="辣椒系列产品"
w(3)="辣椒酱系列"
w(4)="盐(腌)渍辣椒"
w(5)="辣椒粉系列"
w(6)="其 它"%>
<%set com=server.createobject("adodb.connection")
com.open "DBQ="& Server.MapPath("accmdb/acc#co.asp") &";Driver={Microsoft Access Driver (*.mdb)}"
set rs=com.execute("select*from msg where edt>=#" & date & "# ORDER BY id DESC")%>
<%i=0
do while not rs.eof%>
<tr>
<td height="23" valign="top"><table width="325" height="29" border="0" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td width="5" valign="middle"><div align="center"><img src="DOT.gif" width="5" height="5"></div></td>
<td width="233" class=f14><font color="#478B47">
<%response.write "[" & (rs(10)) & "]"%>
</font><a href="show.asp?n=<%response.write rs(0)%>" target="_blank">
<%response.write rs(1)%>
</a> </td>
<td width="56" ><%response.write rs(4)%>
</td>
<td width="31"><div align="center">
<%response.write rs(9)%>
</div></td>
</tr>
</table>
<table border="0" cellspacing="0" style="border-collapse: collapse" bordercolor="#111111" width="325" id="AutoNumber3" cellpadding="0" height="1" bgcolor="#C0E0C6">
<tr>
<td width="100%"></td>
</tr>
</table></td>
<% rs.movenext
i=i+1
if i=5 then exit do
loop
rs.close %>
问题点数:0、回复次数:6Top
1 楼netcomhui(豆乐儿)回复于 2004-09-02 11:44:50 得分 0
这里是演示地址 http://www.ygbiz.com/zgljw/点击供求信息不能打开页面啊,谢谢!!Top
2 楼wittyWYZ(美丽心情)回复于 2004-09-02 11:56:03 得分 0
select*from msg where edt>=#" & date
我看到一个错误,不知道是不是这里引起的,应该写成select * from msg where edt>=#.....
Top
3 楼satans18((何畏)(只要你过得比我好))回复于 2004-09-02 11:59:33 得分 0
找不到供求信息 在哪里啊Top
4 楼netcomhui(豆乐儿)回复于 2004-09-02 14:59:58 得分 0
哦,忘了把数据库上传了。。现在可以看到了Top
5 楼netcomhui(豆乐儿)回复于 2004-09-02 15:21:54 得分 0
对了,美丽心情,我试了一下,好像不行Top
6 楼netcomhui(豆乐儿)回复于 2004-09-02 15:53:49 得分 0
是不是和show.asp有关呢
<td class=f14>
<%set com=server.createobject("adodb.connection")
com.open "DBQ="& Server.MapPath("accmdb/acc#co.asp") &";Driver={Microsoft Access Driver (*.mdb)}"
set rs=com.execute("select*from msg where id="& request("n") )
com.execute("Update msg Set lls=lls+1 Where ID="& request("n"))%>
<div align="center"><strong> <font color="#FF0000">
<%response.write rs(1)%>
[<%response.write rs(10)%>] </font></strong></div></td>
</tr>
<tr>
<td bgcolor="#E6F2FF">
<div align="center"><font color="#006699">·¢²¼Ê±¼ä£º
<%response.write rs(4)%>
ÓÐЧÆÚÏÞ£º
<%response.write rs(5)%>
ä¯ÀÀ£º
<%response.write rs(9)%>
´Î</font></div></td>
</tr>
<tr>
<td class=f14> <br>
<%response.write replace(rs(2),chr(13),"<br><br> ")%>
<br>
<br>
</td>
</tr>
<tr>
<td height="17" bgcolor="#E6F2FF">
<div align="right"><FONT color=#006699>µØÇø£º</FONT>
<%response.write rs(7)%>
<FONT color=#006699>ÁªÏµÈË£º</FONT>
<%response.write rs(11)%>
<FONT color=#006699>EMAIL£º</FONT><a href="mailto:<%response.write rs(6)%>">
<%response.write rs(6)%>
</a><FONT color=#006699>µç»°£º</FONT>
<%response.write rs(8)%>Top




