|
XML can be generated on a server without
installing any XML controls.
Storing XML on the Server
XML files can be stored on an Internet server exactly the
same way as HTML files.
Start Windows Notepad and write the following lines:
<?xml version="1.0" encoding="ISO-8859-1"?>
<note>
<from>Jani</from>
<to>Tove</to>
<message>Remember me this weekend</message>
</note>
|
Save the file on your web server with a proper name like "note.xml".
Generating XML with ASP
XML can be generated on a server without any installed XML
software.
To generate an XML response from the server - simply write
the following code and save it as an ASP file on the web server:
<%
response.ContentType="text/xml"
response.Write("<?xml version='1.0' encoding='ISO-8859-1'?>")
response.Write("<note>")
response.Write("<from>Jani</from>")
response.Write("<to>Tove</to>")
response.Write("<message>Remember me this weekend</message>")
response.Write("</note>")
%>
|
Note that the content type of the response must be set to
"text/xml".
See how the ASP file will
be returned from the server.
If you don't know how to write ASP, please visit our
ASP tutorial
Getting XML From a Database
XML can be generated from a database without any installed
XML software.
To generate an XML database response from the server, simply
write the following code and save it as an ASP file on the web
server:
<%
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)
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()
wend
rs.close()
conn.close()
response.write("</guestbook>")
%>
|
See the real life
database output from the ASP file above.
The example above uses ASP with ADO. If you don't know how to
use ADO, please visit our ADO
tutorial. |
