🚀 go-pugleaf

Ktoś ostatnio pytał mnie o to ale zgubiłem maila więc tu odpowiadam.

Problem dotyczył: jak od zapytania SELECT FOR XML w Sql Serverze przejść do 
xml'a w obiekcie msxml2.domdocument?

var txml=new ActiveXObject('msxml2.domdocument');txml.async=false;
txml.appendChild(txml.createProcessingInstruction('xml','version="1.0"'));
var sConn = 
"Provider=SQLOLEDB;Server=mssql\\sqlexpress;Database=xmlguru;Trusted_Connection=yes";
var adoConn = new ActiveXObject("ADODB.Connection");
adoConn.ConnectionString = sConn;
adoConn.CursorLocation = 3;
adoConn.Open();

var adoCmd = new ActiveXObject("ADODB.Command");
adoCmd.ActiveConnection = adoConn;
var sQuery = "<R 
xmlns:sql='urn:schemas-microsoft-com:xml-sql'><sql:query>SELECT * FROM Users 
WHERE url='xmlguru.net' FOR XML AUTO</sql:query></R>";

var adoStreamQuery = new ActiveXObject("ADODB.Stream");
adoStreamQuery.Open();
adoStreamQuery.WriteText(sQuery,0);
adoStreamQuery.Position = 0;

adoCmd.CommandStream = adoStreamQuery;
adoCmd.Dialect = "{5D531CB2-E6Ed-11D2-B252-00C04F681B71}";

adoCmd.Properties("Output Stream") = txml;
adoCmd.Execute(0,0,1024);
WScript.Echo(txml.xml);

-- 
td