qq头像男生鹿晗的图片:asp数据连接问题?

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/06 13:01:13
下面的代码,我找不到错,请help me
Dim rs1,dbbbs,prefix,timeset,connbbs
Set rs1= Server.CreateObject("ADODB.Connection")
connbbs="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath("nandata/#mmbbs.asp")
%>
<table width="100%" border="0" align="center" cellpadding="1" cellspacing="1">
<%
sql1="select top 5 id,userid,topicinfo,bd,edittime,totable from topic where type<>3 order by hits desc"
set rs1=server.createobject("adodb.recordset")
rs1.open sql1,connbbs,1,1
do while not rs1.eof
%>
<tr><td width="8%"align="right"><img src="Images/Gaobei_skin/Gaobei_ico.gif" width="12" height="11"

align="absmiddle"></td><td width="92%"><p style='line-height: 150%'>
<a href='ViewInfo.asp?id=<%=rs1("id")%>' target='_blank' Title='<%=rs1("title")%>'><%=left(rs1("title"),14)%

>  <font color="#808080"><%=rs1("date")%></font></a><br>
</td></tr>
<%
rs1.movenext
loop
if rs1.eof and rs1.bof then
%>
<tr><td align='center'><div align=center><br>当前还没有图片<br><br></div></td></tr>
<% end if %>
</table>