asked on 4/2/2004

manipulate ADO recordset in Javascript FROM adPersistXML file: need examples!!!

I have saved XML files to the web server using the adPersistXML feature. I will place a reference to the XML file in a data island in my page. I would like to manipulate the XML data as a recordset using the ADO recordset methods in Javascript (or VBScript). I want to loop through records, specify SQL statements and return record values using various recordset objects.

I am having a tough time finding examples of using ADO recordsets from XML in script. Points go to showing the best online resource or examples that move me in the right direction.

Thanks,

Mason

JavaScript

Last Comment

brgivens

4/4/2004

Timbo87

4/3/2004

I think you would be better off doing this server side in ASP/ASP.NET.

brgivens

4/4/2004

test.asp:

<html>
<head>
</head>
<body>
<%

Dim rs

Set rs = Server.CreateObject("ADODB.recordset")
rs.Open Server.MapPath("fileName.xml"), "Provider=MSPersist"

Do While Not rs.EOF
Response.Write rs.Fields("fieldName").Value
rs.MoveNext
Loop

rs.Close

%>
</body>
</html>

codeguy

4/4/2004

ASKER

To clarify:

I want to do this client side (without using ASP). I would prefer to see examples using ADO recordset object in script and not DOM.

Note that I have increased points to 350. Anyone out there!!!!?!?!?

ASKER CERTIFIED SOLUTION

brgivens

4/4/2004

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial