<%on error resume next
connstr="DBQ="+server.mappath("../database/luntan.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)}"
set rs=server.createobject("ADODB.recordset")
sql="select * from corporation where order by ID desc"
rs.open sql,connstr
%>
<MARQUEE behavior=loop direction=up height=130 onmouseout=start(); & onmouseover=stop();scrollAmount=1 scrollDelay=70 width=142>
<font><%=rs("name")%></font><br><br>
</MARQUEE>
<%
Set RS=Nothing
%>
写成这样对吗?
我测试了,页面上没有数据显示
<%on error resume next
connstr="DBQ="+server.mappath("../database/luntan.mdb")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)}"
set conn=server.createobject("ADODB.CONNECTION")
conn.open connstr
set rs=server.createobject("ADODB.recordset")
sql="select * from corporation where order by ID desc"
rs.open sql,connstr
%>
<MARQUEE behavior=loop direction=up height=130 onmouseout=start(); & onmouseover=stop();scrollAmount=1 scrollDelay=70 width=142>
<font><%=rs("name")%></font><br><br>
</MARQUEE>
<%
Set RS=Nothing
%>
这样写对吗?可是没有数据显示