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


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

<div>
<br />
test.asp:<br />
<br />
&lt;html&gt;<br />
&lt;head&gt;<br />
&lt;/head&gt;<br />
&lt;body&gt;<br />
&lt;%<br />
<br />
Dim rs<br />
<br />
Set rs = Server.CreateObject(&quot;ADODB<wbr />.recordset<wbr />&quot;)<br />
rs.Open Server.MapPath(&quot;fileName.x<wbr />ml&quot;), &quot;Provider=MSPersist&quot;<br />
<br />
Do While Not rs.EOF<br />
&nbsp; Response.Write rs.Fields(&quot;fieldName&quot;).Val<wbr />ue<br />
&nbsp; rs.MoveNext<br />
Loop<br />
<br />
rs.Close<br />
<br />
%&gt;<br />
&lt;/body&gt;<br />
&lt;/html&gt;
</div>



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>

<div>
To clarify:<br />
<br />
I want to do this client side (without using ASP). &nbsp;I would prefer to see examples using ADO recordset object in script and not DOM.<br />
<br />
Note that I have increased points to 350. &nbsp;Anyone out there!!!!?!?!?<br />
<br />

</div>


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



<div>
<div class="content wysiwyg-content">
I have saved XML files to the web server using the adPersistXML feature. &nbsp;I will place a reference to the XML file in a data island in my page. &nbsp;I would like to manipulate the XML data as a recordset using the ADO recordset methods in Javascript (or VBScript). &nbsp;I want to loop through records, specify SQL statements and return record values using various recordset objects. &nbsp;<br />
<br />
I am having a tough time finding examples of using ADO recordsets from XML in script. &nbsp;Points go to showing the best online resource or examples that move me in the right direction.<br />
<br />
Thanks,<br />
<br />
Mason
</div>
</div>


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

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

JavaScript is a dynamic, object-based language commonly used for client-side scripting in web browsers. Recently, server side JavaScript frameworks have also emerged. JavaScript runs on nearly every operating system and  in almost every mainstream web browser.