Question

Asp中从数据库中取得的数据实现滚动

<marquee onMouseOver=this.stop() onMouseOut=this.start() scrollamount=1 scrolldelay=1 direction=up width="100%" height=48 border="1"><%=Structure%></MARQUEE>

我要读取的是数据库Main下Structure的数据
怎么才可以实现谢谢了！
要读取的是Main表下的Structure里的文字

Answer 1

'通过Recordset对象查询表

例如在ABC表
set rs = Server.CreateObject("ADODB.Recordset")
sql = "select * from ABC where id=1" '查询语句
rs.Open sql,conn,1,1

'输出查询内容
<marquee onMouseOver=this.stop() onMouseOut=this.start() scrollamount=1 scrolldelay=1 direction=up width="100%" height=48 border="1"><%=Structure%></MARQUEE>

'关闭数据库连接
set rs=nothing
rs.close
set conn=nothing
conn.close
%>

Answer 2

<%
strsql="select * from sturcture"
rs.Open strsql, conn, 1, 1
while not rs.eof %>

<%= rs("structure_id") %>

structure是表名

structure_id是表中要看到的字段名

<marquee onMouseOver=this.stop() onMouseOut=this.start() scrollamount=1 scrolldelay=1 direction=up width="100%" height=48 border="1"><%= rs("structure_id") %></MARQUEE>

Answer 3

<marquee onMouseOver=this.stop() onMouseOut=this.start() scrollamount=1 scrolldelay=1 direction=up width="100%" height=48 border="1">数据库变量</MARQUEE>