XML -> Recordset using jscript

[Sarky78]

Hi all really hoping someone will be able to help me here

I've got some code that will access a webservice and return xml into recordset, this code is in VBScript.

Now, because we are using JScript i need to convert this code to work in the same way. ie into a recordset.

Can anyone help me with this?

this is the code

	'Fetch the data
	set oHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP")
	oHTTP.Open "GET", URL, false
	oHTTP.Send
	
	'Load it into the recordset
	set oRecordset = Server.CreateObject("ADODB.Recordset")
	oRecordset.Open oHTTP.ResponseStream

TIA

Tony

 

[tsuji]

[tt] //Fetch the data
var oHTTP,oRecordset;
oHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP");
oHTTP.Open("GET", URL, false);
oHTTP.Send();

//Load it into the recordset
oRecordset = Server.CreateObject("ADODB.Recordset");
oRecordset.Open (oHTTP.ResponseStream);[/tt]

 

[tsuji]

Correction
Forgotten to do more backspaces. Here is the corrected version.
[tt]
//Fetch the data
var oHTTP,oRecordset;
oHTTP = Server.CreateObject("MSXML2.ServerXMLHTTP");
oHTTP.open("GET", URL, false);
oHTTP.send();

//Load it into the recordset
oRecordset = Server.CreateObject("ADODB.Recordset");
oRecordset.open (oHTTP.ResponseStream);
[/tt]

 

[Sarky78]

Tsuji,

Thanks for this, i've put your code above into the system and now get an error:

ADODB.Recordset error '800a0bb9' 

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

and it indicates the error is on this line:
oRecordset.open (oHTTP.ResponseStream);

any ideas?

Tony

 

[tsuji]

Wrong type error: I cannot help based on the script section. It is not a syntax problem. You know to look into the response proper.

 

[trollacious]

Try this to see what's going on.

Response.Write(oHTTP.ResponseStream);
Response.Flush();

Lee