[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Get Processing Instruction MSXML3.0 sp1

Subject: Get Processing Instruction MSXML3.0 sp1
From: "Jay Gardner" <jgardner@xxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 17 May 2001 16:36:08 -0500
get processing instruction
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


Current Thread

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.