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:
<map:generate type="file"
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]
