How to get XML format from SQL2000 and load by ASP

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

How to get XML format from SQL2000 and load by ASP

Author

Topic

chchsi
Starting Member

2 Posts

Posted - 2003-06-01 : 01:08:21

Dear Expert,

I had installed SQL2000 and created few tables. Now i'm trying to execute the "SELECT * FROM Product FOR XML AUTO" to get the XML string.

May i know that, how can i execute above statement in ASP and get back the return XML to ASP coding.

Thanks

jasper_smith
SQL Server MVP & SQLTeam MVY

846 Posts

Posted - 2003-06-01 : 08:00:48

For all your SQLXML needs check out [url]http://sqlxml.org/default.aspx[/url]
For your specific question [url]http://sqlxml.org/faqs.aspx?faq=2[/url]

HTH
Jasper Smith

0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27

chchsi
Starting Member

2 Posts

Posted - 2003-06-01 : 22:26:02

Dear Jasper Smith,

Thanks for your kindly help. I had tested the script from the below url "http://sqlxml.org/faqs.aspx?faq=2".

I got this error message.

Microsoft XML Extensions to SQL Server (0x80040E14)
MSXML3: Invalid at the top level of the document.
/ats/xmltest2.asp, line 25

Kindly advice me on this.

Thanks

Best regards,
Gary

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources