Avatar of codeguy
codeguy asked on

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

Avatar of undefined
Last Comment
brgivens

8/22/2022 - Mon
Timbo87

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


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>
ASKER
codeguy

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!!!!?!?!?

Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
ASKER CERTIFIED SOLUTION
brgivens

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question