asp to xml sheet

[Fary4u]

Hi

i'm trying to find some code that can genrate asp result to xml sheet

My xml version is <?xml version="1.0" encoding="utf-8" standalone="yes"?>

<%
response.ContentType = "text/xml"
set conn=Server.CreateObject("ADODB.Connection") 
conn.provider="Microsoft.Jet.OLEDB.4.0;"
conn.open server.mappath("/db/database.mdb")sql="select fname,lname from tblGuestBook"
set rs=Conn.Execute(sql)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>")
%>
 

thanks in advance

[DrBunchman]

Hi Fary4u,

I've tested your code and the xml content doesn't display in IE. In FireFox however it works fine! Can you give that a try please and let me know if it works for you also?

I'll try and look into this one a bit further.

Dr B

[jhardman]

you should be able to validate your XML with the W3C, just to make sure there are no errors.

Jared

[DrBunchman]

Fary4u, did you ever get this fixed? I'd be interested to know what the problem was if you did.

If not, did you ever try it in FireFox?

Best Regards,

Dr B

[Fary4u]

Yep i've done it & getting record from the database write xml sheet before saving it into the database.

it's working fine there was no problem i'm using this wd Flash components to access records 1 after another.