|
[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Get Processing Instruction MSXML3.0 sp1
Hello all,
I am having a little trouble with SQL Server 2000 XML capabilities.
I am using templates and sending the template a parameter for the sql
statement. The query can generate an error if an incorrect value is
sent. Normally this will not happen, but if it does I want to parse
the XML returned from SQL Server.
Here is a sample error from SQL Server:
<?xml version="1.0" encoding="UTF-8" ?>
<root xmlns:sql="urn:schemas-microsoft-com:xml-sql">
<?MSSQLError HResult="0x80040e14" Source="Microsoft OLE DB Provider
for SQL Server" Description="Syntax error converting from a
character
string to uniqueidentifier."?>
</root>
I am using the MSXML3 parser on a W2 server, and I am having a hard time
gaining a reference to the processing instruction MSSQLError. I have
been
trying to use selectSingleNode("//MSSQLError") but have had no luck.
Is there a way gain access to the processing instructions using an XPath
query?
Thanks,
Jay Gardner
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
|
PURCHASE STYLUS STUDIO ONLINE TODAY!Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced! Download The World's Best XML IDE!Accelerate XML development with our award-winning XML IDE - Download a free trial today! Subscribe in XML format
|

Cart








