Re: Using SQLXML within Cocoon
Stewart, Gary wrote:
Hi people,
I was looking at SQLXML which is a tool for MS SQL Server and using that within
Cocoon. Effectively what I'm looking to do is have an SQL transformer that
sends the query to the database (the query might be an XPath query rather than
a straight up SQL query) and receive XML data back directly from the database
rather than the usual rows returned. I was wondering if anyone had an
experience of trying this before and if so what components they used to achieve
it.
Thanks,
Gary
Hi Gary!
Since SQLXML is an extension to IIE, you can simply query it via its
URL, like this:
src="http://{host}:{port}/{path-to-xsd}/{shcema.xsd}/{xpath}?root=root"/>
It's an easy and powerful way to retrieve data from SQLServer.
Askild
-
-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Re: Using SQLXML within Cocoon
several years ago, I use xmldbms, a java program, can execute under command line. Best Regards johnson - Original Message - From: "Stewart, Gary" <[EMAIL PROTECTED]> To: Sent: Thursday, September 29, 2005 11:25 PM Subject: Using SQLXML within Cocoon Hi people, I was looking at SQLXML which is a tool for MS SQL Server and using that within Cocoon. Effectively what I'm looking to do is have an SQL transformer that sends the query to the database (the query might be an XPath query rather than a straight up SQL query) and receive XML data back directly from the database rather than the usual rows returned. I was wondering if anyone had an experience of trying this before and if so what components they used to achieve it. Thanks, Gary * The information contained in this message may be confidential or legally privileged and is intended for the addressee only, If you have received this message in error or there are any problems, please notify the originator immediately. The unauthorised use, disclosure, copying or alteration of this message is strictly forbidden. * - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Using SQLXML within Cocoon
Hi people, I was looking at SQLXML which is a tool for MS SQL Server and using that within Cocoon. Effectively what I'm looking to do is have an SQL transformer that sends the query to the database (the query might be an XPath query rather than a straight up SQL query) and receive XML data back directly from the database rather than the usual rows returned. I was wondering if anyone had an experience of trying this before and if so what components they used to achieve it. Thanks, Gary * The information contained in this message may be confidential or legally privileged and is intended for the addressee only, If you have received this message in error or there are any problems, please notify the originator immediately. The unauthorised use, disclosure, copying or alteration of this message is strictly forbidden. * - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
