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

RE: Get Processing Instruction MSXML3.0 sp1

Subject: RE: Get Processing Instruction MSXML3.0 sp1
From: "Joshua Allen" <joshuaa@xxxxxxxxxxxxx>
Date: Thu, 17 May 2001 19:27:02 -0700
mssqlerror
match="processing-instruction('MSSQLError')|processing-instruction('MSRT
SError')" works as a match expression in XSLT, so I would assume that
selectSingleNode("processing-instruction('MSSQLError')") would work.
Note that the MSRTSError is used by custom errors you might throw from a
stored procedure.

> -----Original Message-----
> From: Jay Gardner [mailto:jgardner@xxxxxxxxxxxxxxxxxxxxxx]
> Sent: Thursday, May 17, 2001 2:36 PM
> To: xsl-list@xxxxxxxxxxxxxxxxxxxxxx
> Subject:  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


 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.