ASP--fin---XML

[KidD32]

a ver si te sirve

Código:

Crear un XML
==============

-Javascript
	var xmlDoc=new ActiveXObject("Microsoft.XMLDOM")

-VB Scritp
	set xmlDoc=CreateObject("Microsoft.XMLDOM")

-VB Scritp
	set xmlDoc=Server.CreateObject("Microsoft.XMLDOM")


Crear desde ASP
=================

<%
response.ContentType = "text/xml"

set conn=Server.CreateObject("ADODB.Connection") 
conn.provider="Microsoft.Jet.OLEDB.4.0;"
conn.open server.mappath("/ado/database.mdb")
sql="select fname,lname from tblGuestBook"
set rs=Conn.Execute(sql)rs.MoveFirst()response.write("<?xml version='1.0' encoding='ISO-8859-1'?>")
response.write("<guestbook>")
while (not rs.EOF)
  response.write("<guest>")
  response.write("<fname>" & rs("fname") & "</fname>")
  response.write("<lname>" & rs("lname") & "</lname>")
  response.write("</guest>")
  rs.MoveNext()
wendrs.close()
conn.close()
response.write("</guestbook>")
%>


Para mostrar en una tabla
=========================

<xml src="cd_catalog.xml" id="xmldso" async="false">
</xml>
<table datasrc="#xmldso" width="100%" border="1">

<thead>
<th>Title</th>
<th>Artist</th>
<th>Year</th>
</thead>

<tr align="left">
<td><span datafld="TITLE"></span></td>
<td><span datafld="ARTIST"></span></td>
<td><span datafld="YEAR"></span></td>
</tr></table>