Muhammad, you can:
1) Use SQL Transformer (write your query in an XML file and pass it through this transformer). 2) Use ESQL (write your query in an XSP file and process it via the serverpages generator) Regarding the use of XSL when no XML file is available... you could use the request generator to create a generic XML "file" (it is not a physical one, of course, just a stream of SAX events) which you can later run your XSL on. Hope this helps, --------------------------------------------- Luca Morandini GIS Consultant [EMAIL PROTECTED] http://utenti.tripod.it/lmorandini/index.html --------------------------------------------- > -----Original Message----- > From: Muhammad Irfan [mailto:[EMAIL PROTECTED]] > Sent: Saturday, April 13, 2002 1:17 AM > To: [EMAIL PROTECTED] > Subject: My First Cocoon Question!! > > > > Dear Cocooners, > Hi, > > I want to use cocoon to query MS Access database and want to > get the query > results in xml as output. I have setup the database driver in web.xml > <init-param> and have made all satisfactory changes. The only decision > problem i am facing is that should i write xsl file that states the SQL > query but there is no xml file to tranform. or should i approach any other > method. Any idea or help will be greatly appreciated. > > Thanks alot to all > > Irfan > > > > _________________________________________________________________ > Join the world’s largest e-mail service with MSN Hotmail. > http://www.hotmail.com > > > --------------------------------------------------------------------- > Please check that your question has not already been answered in the > FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> > > To unsubscribe, e-mail: <[EMAIL PROTECTED]> > For additional commands, e-mail: <[EMAIL PROTECTED]> > --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>