Re: XQuery Exists Namespace Issue

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Martin Honnen <mahotrash@xxxxxxxx>
Date: Wed, 18 Apr 2007 15:29:14 +0200

dreck@xxxxxxxxx wrote:

DECLARE @x XML
SET @x = '<X12_4010_837 xmlns="http://schemas.wpc-edi.com/X12/ISOMORPH/
HIPAA/4010A1/TS837Q1">
<X12_EnvelopeHeader>
<ISA_InterchangeControlHeader>
<ISA01__AuthorizationInformationQualifier>00
</ISA01__AuthorizationInformationQualifier>
</ISA_InterchangeControlHeader>
</X12_EnvelopeHeader>
</X12_4010_837>';

IF(@x.exist('/*/X12_EnvelopeHeader/ISA_InterchangeControlHeader/
ISA01__AuthorizationInformationQualifier [1]' ) = 1)

Use e.g.

IF(@x.exist('declare default element namespace "http://schemas.wpc-edi.com/X12/ISOMORPH/HIPAA/4010A1/TS837Q1";; /*/X12_EnvelopeHeader/ISA_InterchangeControlHeader/ISA01__AuthorizationInformationQualifier [1]' ) = 1)

--

Martin Honnen --- MVP XML
http://JavaScript.FAQTs.com/
.

Follow-Ups:
- Re: XQuery Exists Namespace Issue
  - From: dreck

References:
- XQuery Exists Namespace Issue
  - From: dreck

Prev by Date: XQuery Exists Namespace Issue
Next by Date: Re: Get data out of a table using a schema through select statement
Previous by thread: XQuery Exists Namespace Issue
Next by thread: Re: XQuery Exists Namespace Issue
Index(es):
- Date
- Thread