数据岛问题

发布时间:2024-05-14 08:46 发布:上海旅游网

问题描述:

<html>
<head>
<xml id="xmldso" src="xml001.asp" async="false"></xml>
<script language="javascript">
document.write(xmldso.xml);
/*这个怎么没有数据,是空的。请帮忙解决一下。*/
</script>
</head>
<body>
<input type=button name=b1 value=下一记录 onclick=next()>
<input type=button name=b2 value=记录数 onclick=show()>
</body>
</html>

<!--xml001.asp-->
<%
Dim sqlstr
sqlstr="select * from authors"
Set conn=server.createobject("adodb.connection")
Set rs=server.createobject("adodb.recordset")
conn.open"provider=sqloledb;data source=(local);uid=sa;pwd=;database=pubs"
rs.open sqlstr,conn,3,1
response.write "<?xml version='1.0' encoding='gb2312'?>"
response.write "<depts>"
if Not rs.eof Then
While Not rs.eof And Not rs.bof
response.write "<dept>"
response.write "<ID>"&rs("au_id")&"</ID>"
response.write "<name>"&rs("au_lname")&"</name>"
response.write "</dept>"
rs.movenext
Wend
End If
response.write "</depts>"
rs.Close
set rs=nothing
%>

问题解答:

数据岛问题这个旅游问答期待您的解答,请登录账号或关注微信公众号回答这个问题。

热点新闻