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:
|
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:
<% |
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("")
response.write("")
while (not rs.EOF)
response.write("")
response.write("" & rs("fname") & " ")
response.write("" & rs("lname") & " ")
response.write(" ")
rs.MoveNext()
wend rs.close()
conn.close()
response.write("")
%>
