求asp高手救命,请教,急救,弄来一下午,没搞懂,太菜 了
最后一段出的问题,从另一个表里读不出数据,我是菜鸟,高手应该一看就明白,现在这段代码的结果我也截了图的<table width="676" height="103" border="0" align="center" cellpadding="0" cellspacing="1" borderColor="#111111" bgcolor="#FFCC99" id="AutoNumber5" style="BORDER-TOP-WIDTH: 0px; BORDER-LEFT-WIDTH: 0px; BORDER-BOTTOM-WIDTH: 0px; BORDER-COLLAPSE: collapse; BORDER-RIGHT-WIDTH: 0px">
<tr bgColor="#f7f7f7">
<td height="33" bgcolor="#FFFFFF"><div align="center"> 所属楼盘</div></td>
<td width="19%" height="33" bgcolor="#FFFFFF">
<p align="center">信息标题</td>
<td height="33" bgcolor="#FFFFFF">
<p align="center">单 价<br>
</td>
<td height="33" bgcolor="#FFFFFF">
<div align="center"></div> </td>
<td height="33" bgcolor="#FFFFFF">
<div align="center"></div> </td>
<td height="33" bgcolor="#FFFFFF">
<div align="center">
发布时间</div> </td>
</tr>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from [rent] where by_shenhe=1 and if_exist=1 and retain=1 and if_shunpan=0 order by adddate desc"
rs.open sql,conn,1,1
if rs.recordcount=0 then
else
rs.PageSize =30 '每页记录条数
iCount=rs.RecordCount '记录总数
iPageSize=rs.PageSize
maxpage=rs.PageCount
page=request("page")
if Not IsNumeric(page) or page="" then
page=1
else
page=cint(page)
end if
if page<1 then
page=1
elseif page>maxpage then
page=maxpage
end if
rs.AbsolutePage=Page
if page=maxpage then
x=iCount-(maxpage-1)*iPageSize
else
x=iPageSize
end if
For mfki_1=1 To x
%>
<tr bgcolor="#FFFFFF" onMouseOver="this.bgColor='#FFD28E';" onMouseOut="this.bgColor='#FFFFFF'" >
<td width="17%" rowspan="3" align="left" valign="middle" >
</span>
</font>
<%
set rsb=server.CreateObject("adodb.recordset")
sqlb="select * from build where title="&trim(rs("buildtitle"))
rsb.open
sqlb,conn,1,1
if not rs.eof and not rs.bof then
response.Write(sqlb) %>
<img src="<%=rsb("pico")%>" width="80" height="80">
<%else%>
<img src="images/59-0.jpg" width="80" height="80">
<%
end if
rsb.close
set rsb=nothing %> </td>
<td colspan="4" align="left" valign="middle" > <a title="<%=trim(rs("title"))%>" target="_top" href="rentinfo.asp?id=<%=rs("id")%>">
右击图属性没有连接地址,我确信数据库有图,字段是pico,我弄了一个下午了,哎 菜就是菜啊