ASP Classic SQL Server以XML格式从数据库返回结果

问题描述

我正在尝试从ASP中的查询返回结果，当我使用诸如Response.write Recordset(0)之类的东西时，它可以工作，但是它不能以xml格式工作.这是我的代码:

I'm trying to return results from query in ASP, it's working when I use something like Response.write Recordset(0) but it's not working in xml format. Here is my code:

Dim conn
Dim Recordset
Dim xmlDoc 

Set conn = Server.CreateObject("ADODB.Connection")
Set Recordset = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT * FROM dbo.myTable for xml auto;"

conn.Open "Provider=SQLOLEDB; Data Source = myPC\SQLEXPRESS;
Initial Catalog = peopleDatabase; User Id = rafalsonn; Password=xxx"
Recordset.Open SQL,conn
Set xmlDoc = Server.CreateObject("Microsoft.XMLDOM")
Recordset.Save xmlDoc,1

Recordset.Close
Set Recordset=nothing
conn.Close
Set conn=nothing
Response.Write xmlDoc.xml

结果:

我已经尝试使它工作很长时间了，但是我不知道该错误在哪里.问候拉法(Rafał)

I've tried to make it work for a long time, but I don't know where the bug is. Greetings, Rafał

推荐答案

这是另一种方式.

在ADO的 XML持久性格式.

<%
Response.ContentType = "text/xml"

Const adPersistXML = 1
Dim conn
Dim Recordset

Set conn = Server.CreateObject("ADODB.Connection")
Set Recordset = Server.CreateObject("ADODB.Recordset")
SQL = "SELECT * FROM dbo.myTable"
conn.Open "Provider=SQLOLEDB; Data Source = myPC\SQLEXPRESS; Initial Catalog = peopleDatabase; User Id = rafalsonn; Password=xxx"
Recordset.Open SQL,conn, 1, 1
Recordset.Save Response, adPersistXML 
%>

---

相关链接:

• 保存方法
• 以XML格式保存记录
• XML持久性格式

---

Related Links:

• Save Method
• Persisting Records in XML Format
• XML Persistence Format

这篇关于ASP Classic SQL Server以XML格式从数据库返回结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！