xsl-list
[Top] [All Lists]

Re: [xsl] Connecting to Data Base using XSL

2007-09-12 00:10:16
Hi Karanam,

if the webservice is a REST-based webservice, meaning that it returns
the XML via a http GET then yes, using
document("http:// location of webservice to do query")
If not then you are again stuck requiring an extension function.

The first two responses I get to this search
http://www.google.com/search?source=ig&hl=en&q=soap+xsl show extension
functions for different processors for doing SOAP. I suppose whatever
processor you are using you can find an extension function for working
with SOAP for it.

There also used to be the following, for MSXML I believe,
http://www.topxml.com/soapworkshop/utilities/kafka/default.asp but not
sure how maintained it still is.

Best regards,
Bryan Rasmussen

On 9/12/07, Karanam(_dot_)Chowdary(_at_)iflexsolutions(_dot_)com
<Karanam(_dot_)Chowdary(_at_)iflexsolutions(_dot_)com> wrote:
Extension function???? I have a webservice which queries from database
and returns the desired results. Can that webservice be included in my
XSL?

-----Original Message-----
From: bryan rasmussen [mailto:rasmussen(_dot_)bryan(_at_)gmail(_dot_)com]
Sent: Wednesday, September 12, 2007 10:47 AM
To: xsl-list(_at_)lists(_dot_)mulberrytech(_dot_)com
Subject: Re: [xsl] Connecting to Data Base using XSL

either you will need to use an extension function appropriate to your
processor or the database would have to be exposed via some protocol
accessible via the document() function - the second seems unlikely.

Best regards,
Bryan Rasmussen

On 9/12/07, Karanam(_dot_)Chowdary(_at_)iflexsolutions(_dot_)com
<Karanam(_dot_)Chowdary(_at_)iflexsolutions(_dot_)com> wrote:


Hello,
Can someone help me out in connecting to database using xsl?
I have to connect to oracle 10g database and retrieve data and display
it in browser. Say, I have control id in my xml, based on this control
id I have to get the control name which is in the database. I tried
using saxon, but I want the results to be displayed in browser not in
cmd prompt.

This is my XML:
<CONTAINER ID="1" TYPE="1" CREATEDIV="Y">
                <CONTROL_ID>2</CONTROL_ID>
                <CONTROL_ID>3</CONTROL_ID>
                <CONTROL_ID>7</CONTROL_ID>
</CONTAINER>
I shud get the control name from database using the <CONTROL_ID> tag
in
XML.

Note: I m not using any XSLT processor... just editing XSL with Visual
Studio 2005.


DISCLAIMER:
This message contains privileged and confidential information and is
intended only for an individual named. If you are not the intended
recipient, you should not disseminate, distribute, store, print, copy or
deliver this message. Please notify the sender immediately by e-mail if
you have received this e-mail by mistake and delete this e-mail from
your system. E-mail transmission cannot be guaranteed to be secure or
error-free as information could be intercepted, corrupted, lost,
destroyed, arrive late or incomplete or contain viruses. The sender,
therefore,  does not accept liability for any errors or omissions in the
contents of this message which arise as a result of e-mail transmission.
If verification is required, please request a hard-copy version.

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: 
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: 
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



DISCLAIMER:
This message contains privileged and confidential information and is intended 
only for an individual named. If you are not the intended recipient, you 
should not disseminate, distribute, store, print, copy or deliver this 
message. Please notify the sender immediately by e-mail if you have received 
this e-mail by mistake and delete this e-mail from your system. E-mail 
transmission cannot be guaranteed to be secure or error-free as information 
could be intercepted, corrupted, lost, destroyed, arrive late or incomplete 
or contain viruses. The sender, therefore,  does not accept liability for any 
errors or omissions in the contents of this message which arise as a result 
of e-mail transmission. If verification is required, please request a 
hard-copy version.

--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: 
<mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--



--~------------------------------------------------------------------
XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--

<Prev in Thread] Current Thread [Next in Thread>