You can use Oracle's XSQL utility to create a XML document from the database ,
the tag names are the column names.
ex if you select columsn a,b,c from a table then a , b and c will be your tag
names and the content of the tags is the value of the columns
You can download this utility from Oracle's site. Once you have the XML
document created you can use XSL to transform it into HTML.
Santosh
Arunkumar S Keserla <[EMAIL PROTECTED]> on 10/11/2000 01:34:11 PM
Please respond to A mailing list about Java Server Pages specification and
reference <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
cc: (bcc: Santosh Daryani/IT/Aon Consulting)
Subject: JSP to XML
Hi
I was trying to implement an application in which I was supposed to get data
from a Database. I wanted to use XML as a Middle tier and then use XSL to
convert it to HTML or WML appropriately.
I am not sure how to convert data in Database to XML format, should i try to
put tags on my own or is there any cleaner way of doing it.
Thanks
Arun
----------------------------------------------------------------------
1031 S Racine Ave, 1st Floor
Chicag0, IL - 60607
ph: (h) 312 666 7686
(w) 312 996 5802
----------------------------------------------------------------------
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
