28,391
社区成员
发帖
与我相关
我的任务
分享从数据库中提取出的数据怎么才能让它自动换行。以下是代码
<!--#include file="vbadodb.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sql="select * from News where id="& replace(request("id"),"'","")
rs.open sql,conn,1,1
if not rs.eof then
%>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="6%" height="241" rowspan="2" align="left" valign="top"><script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0','width','60','height','550','src','swf/lefttop','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','scale','noborder','movie','swf/lefttop' ); //end AC code
</script>
<noscript>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="60" height="550">
<param name="movie" value="swf/lefttop.swf" />
<param name="quality" value="high" />
<param name="SCALE" value="noborder" />
<embed src="swf/lefttop.swf" width="60" height="550" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" scale="noborder"></embed>
</object>
</noscript>
</td>
<td width="10%" height="126" align="left" valign="top" class="righttop1"> </td>
<td width="665" rowspan="2" align="center" valign="top">
<table width="665" height="75" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="75"><img src="img/banna5.jpg" width="100%" height="73" border="0" usemap="#Map3" /></td>
</tr>
</table>
<table width="661" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="45" colspan="2" valign="bottom" id="tablebottom"><img src="img/news.jpg" border="0" usemap="#Map2" />
<map name="Map2" id="Map2"><area shape="rect" coords="616,1,666,19" href="news.asp" />
<area shape="rect" coords="576,2,603,18" href="index.asp" />
</map> </td>
</tr>
<tr height="5">
<td width="173" height="217" rowspan="2" align="left" valign="top"><div id="imgs"><img src="img/dff.jpg" width="145" height="194" /></div></td>
<td width="488" align="left" valign="top" height="25" class="righttop4"><div id="cn"> <%=rs("New_title")%> </div> </td>
</tr>
<tr height="5">
<td width="488" height="375" align="left" valign="top">
<table border="0" align="center" cellpadding="0" cellspacing="0" width="482">
<tr>
<td class="righttop4">
<table border="0" cellspacing="1" width="482" height="104" class="style4">
<tr>
<td width="95%" height="16"> </td>
</tr>
<tr>
<td height="68" align="left"><%
if rs("flag")=1 then
%>
<table width="200" align="left">
<tr>
<td><a href="admin/news/<%=rs("New_pic")%>" target="_blank"></a> </td>
</tr>
</table>
<%end if%>
<div id="News">
<%
if rs("New_Body")<>"" then
response.write replace(rs("New_Body"),chr(13)+chr(10),"<br>")
end if
%>
</div></td>
</tr>
<tr>
<td width="95%" height="16" class="link"></td>
</tr>
</table>
<%
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</td>
</tr>
</table><br />
<a href="javascript:history.back()">返回</a> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td colspan="2" valign="bottom"><br /><hr size="1" color="#999999" width="100%" />
<div id="bottom">上海巨拓通信电子有限公司 版权所有 Copyright 2005-2007</div></td>
</tr>
</table> </td>
<td width="16%" rowspan="2" align="center" valign="top" class="righttop2"> </td>
</tr>
<tr>
<td align="right" valign="top" class="righttop1"><script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0','width','80','height','430','src','swf/leftmenu','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','scale','noborder','movie','swf/leftmenu' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="80" height="430">
<param name="movie" value="swf/leftmenu.swf" />
<param name="quality" value="high" /><param name="SCALE" value="noborder" />
<embed src="swf/leftmenu.swf" width="80" height="430" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" scale="noborder"></embed>
</object></noscript></td>
</tr>
</table>
<map name="Map" id="Map">
<area shape="rect" coords="116,18,198,39" href="product.html" alt="点击进入无线射频测试" />
<area shape="rect" coords="208,18,301,39" href="#" alt="点击进入手机综合测试仪" />
<area shape="rect" coords="311,18,395,40" href="#" alt="点击进入网络优化测试 "/>
</map>
<map name="Map3" id="Map3">
<area shape="rect" coords="143,19,205,37" href="product.html" />
<area shape="rect" coords="209,19,268,38" href="#" /><area shape="rect" coords="275,18,335,38" href="transfers.html" />
</map></body>
<%
set rs=server.createobject("adodb.recordset")
sql="select * from News where id="& replace(request("id"),"'","")
rs.open sql,conn,1,1
if not rs.eof then
%>
<body>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="6%" height="241" rowspan="2" align="left" valign="top"><script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0','width','60','height','550','src','swf/lefttop','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','scale','noborder','movie','swf/lefttop' ); //end AC code
</script>
<noscript>
<object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="60" height="550">
<param name="movie" value="swf/lefttop.swf" />
<param name="quality" value="high" />
<param name="SCALE" value="noborder" />
<embed src="swf/lefttop.swf" width="60" height="550" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" scale="noborder"></embed>
</object>
</noscript>
</td>
<td width="10%" height="126" align="left" valign="top" class="righttop1"> </td>
<td width="665" rowspan="2" align="center" valign="top">
<table width="665" height="75" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td height="75"><img src="img/banna5.jpg" width="100%" height="73" border="0" usemap="#Map3" /></td>
</tr>
</table>
<table width="661" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="45" colspan="2" valign="bottom" id="tablebottom"><img src="img/news.jpg" border="0" usemap="#Map2" />
<map name="Map2" id="Map2"><area shape="rect" coords="616,1,666,19" href="news.asp" />
<area shape="rect" coords="576,2,603,18" href="index.asp" />
</map> </td>
</tr>
<tr height="5">
<td width="173" height="217" rowspan="2" align="left" valign="top"><div id="imgs"><img src="img/dff.jpg" width="145" height="194" /></div></td>
<td width="488" align="left" valign="top" height="25" class="righttop4"><div id="cn"> <%=rs("New_title")%> </div> </td>
</tr>
<tr height="5">
<td width="488" height="375" align="left" valign="top">
<table border="0" align="center" cellpadding="0" cellspacing="0" width="482">
<tr>
<td class="righttop4">
<table border="0" cellspacing="1" width="482" height="104" class="style4">
<tr>
<td width="95%" height="16"> </td>
</tr>
<tr>
<td height="68" align="left"><%
if rs("flag")=1 then
%>
<table width="200" align="left">
<tr>
<td><a href="admin/news/<%=rs("New_pic")%>" target="_blank"></a> </td>
</tr>
</table>
<%end if%>
<div id="News">
<%
if rs("New_Body")<>"" then
response.write replace(rs("New_Body"),chr(13)+chr(10),"<br>")
end if
%>
</div></td>
</tr>
<tr>
<td width="95%" height="16" class="link"></td>
</tr>
</table>
<%
end if
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
</td>
</tr>
</table><br />
<a href="javascript:history.back()">返回</a> </td>
</tr>
</table>
<table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td colspan="2" valign="bottom"><br /><hr size="1" color="#999999" width="100%" />
<div id="bottom">上海巨拓通信电子有限公司 版权所有 Copyright 2005-2007</div></td>
</tr>
</table> </td>
<td width="16%" rowspan="2" align="center" valign="top" class="righttop2"> </td>
</tr>
<tr>
<td align="right" valign="top" class="righttop1"><script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0','width','80','height','430','src','swf/leftmenu','quality','high','pluginspage','http://www.macromedia.com/go/getflashplayer','scale','noborder','movie','swf/leftmenu' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="80" height="430">
<param name="movie" value="swf/leftmenu.swf" />
<param name="quality" value="high" /><param name="SCALE" value="noborder" />
<embed src="swf/leftmenu.swf" width="80" height="430" quality="high" pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" scale="noborder"></embed>
</object></noscript></td>
</tr>
</table>
<map name="Map" id="Map">
<area shape="rect" coords="116,18,198,39" href="product.html" alt="点击进入无线射频测试" />
<area shape="rect" coords="208,18,301,39" href="#" alt="点击进入手机综合测试仪" />
<area shape="rect" coords="311,18,395,40" href="#" alt="点击进入网络优化测试 "/>
</map>
<map name="Map3" id="Map3">
<area shape="rect" coords="143,19,205,37" href="product.html" />
<area shape="rect" coords="209,19,268,38" href="#" /><area shape="rect" coords="275,18,335,38" href="transfers.html" />
</map></body>
...全文
请发表友善的回复…
发表回复
yisheng163 2007-03-28
- 打赏
- 举报
我一般是定义一个table 装这些数据
循环的时候 循环<tr>
<table width="" height="" align="center" border="0" cellpadding="0" cellspacing="0" bgcolor="">
<tr align="center">
<td align="center"> </td>
</tr>
<%
Set rs = Server.CreateObject("ADODB.Recordset")
sql ="select * from 表名 where id=1 order by id desc"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
rs.close
response.write "<center>没有信息"
else
do while not rs.eof
%>
<tr align="center">
<td align="center"> </td>
</tr>
<%
rs.movenext
loop
rs.close
end if
set rs=nothing
%>
</table>
循环的时候 循环<tr>
<table width="" height="" align="center" border="0" cellpadding="0" cellspacing="0" bgcolor="">
<tr align="center">
<td align="center"> </td>
</tr>
<%
Set rs = Server.CreateObject("ADODB.Recordset")
sql ="select * from 表名 where id=1 order by id desc"
rs.open sql,conn,1,1
if rs.bof and rs.eof then
rs.close
response.write "<center>没有信息"
else
do while not rs.eof
%>
<tr align="center">
<td align="center"> </td>
</tr>
<%
rs.movenext
loop
rs.close
end if
set rs=nothing
%>
</table>
sdsssafa 2007-03-28
- 打赏
- 举报
数据多的话，显示是一行，把原有的布局都撑变形了，
