wood burning stoves 2.0*
The moose likes XML and Related Technologies and the fly likes dynamic data updation-XML ms ACCESS-ASP-IIS Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Engineering » XML and Related Technologies
Bookmark "dynamic data updation-XML ms ACCESS-ASP-IIS" Watch "dynamic data updation-XML ms ACCESS-ASP-IIS" New topic
Author

dynamic data updation-XML ms ACCESS-ASP-IIS

sathya murthy
Greenhorn

Joined: Jun 27, 2005
Posts: 3
i am having a database named "personaldb.mdb" which contains a table named "personnaldetails" in ms access and i could retrive the data as an xml file by using ASP+IIS combination. if i do changes in the table it reflects sometimes in xml file and sometimes if i refresh i wont get the updated data even if i delete all temporary internet files...
how to run the same ASP file in tomcat 5.0.?
thanks in advance...
here is my ASP file:


<%@ Language=VBScript %>
<?xml version="1.0"?>
<personal>
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Provider="Microsoft.Jet.OLEDB.4.0"
Conn.Open "D:\asp\personaldb.mdb"
Set Tape = Conn.Execute("select * from personaldetails")
Do While Not Tape.EOF
%>
<song>
<sno><%=Tape("sno")%></sno>
<name><%=Tape("name")%></name>
<dob><%=Tape("dob")%></dob>
</song>
<% Tape.MoveNext
Loop
%>
</personal>

my XML output is:

<?xml version="1.0" ?>
<personal>
<song>
<sno>5555</sno>
<name>Rukku</name>
<dob>2/2/2002</dob>
</song>
<song>
<sno>2222</sno>
<name>Ramesh</name>
<dob>2/2/2004</dob>
</song>
<song>
<sno>31</sno>
<name>Sathya moorthy</name>
<dob>1/5/1989</dob>
</song>
<song>
<sno>5</sno>
<name>Sank</name>
<dob>2/2/1998</dob>
</song>
</personal>
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
 
subject: dynamic data updation-XML ms ACCESS-ASP-IIS
 
Similar Threads
JSP to PDF
date range in xsl
passing parameters
whitespace...
xsl variable and xsl:if