• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 602
  • Last Modified:

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
0
codeguy
Asked:
codeguy
  • 2
1 Solution
 
Timbo87Commented:
I think you would be better off doing this server side in ASP/ASP.NET.
0
 
brgivensCommented:

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>
0
 
codeguyAuthor Commented:
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!!!!?!?!?

0
 
brgivensCommented:
You can't do it client side.  Javascript is not able to access files - its scope is entirely confined to the browser.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now