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

Expand|Select|Wrap|Line Numbers

 
<%

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.

asp to xml sheet

re: asp to xml sheet

re: asp to xml sheet

re: asp to xml sheet

re: asp to xml sheet

Similar ASP / Active Server Pages bytes

/bytes/development

/bytes/it

/bytes/about