SSDN - SQL Server 2005 XQuery help

XML Editor

Sign Up

Search

Options

Chat

Help

News

Log in

Not Logged in

Topic

Anees Shaik

Subject: SQL Server 2005 XQuery help
Author: Anees Shaik
Date: 07 Nov 2007 03:47 PM

Hi,
I am new to XQuery. I am trying to check the value of one field and then if it mathces I want to associate data in another field to the target element in the resulting XML file. I am using a xml schema. How can I do this using the mapper in XQuery builder.

(Deleted User)

Subject: SQL Server 2005 XQuery help
Author: (Deleted User)
Date: 09 Nov 2007 05:49 AM

Hi,
could you post a sample XML with a detailed description of what you are trying to match and replace?

Thanks,
Alberto

Anees Shaik

Subject: SQL Server 2005 XQuery help
Author: Anees Shaik
Date: 09 Nov 2007 12:27 PM

I have attached a document that explains what I am trying to accomplish.

Thanks for your help.

ForumQuestion.doc

(Deleted User)

Subject: SQL Server 2005 XQuery help
Author: (Deleted User)
Date: 14 Nov 2007 02:41 AM

Hi,
just right click again and pick "Conditional block" followed by "=".
Drag the Question node to the first input, double click on the second and enter "NSN".
Right click again on the middle pane, and pick the "If block" menu entry.
Drag the output of the "=" block to the input port of the "if", and the top output of the "if" to the NSN node

Hope this helps,
Alberto

Powered by Stylus Studio, the world's leading XML IDE for XML, XSLT, XQuery, XML Schema, DTD, XPath, WSDL, XHTML, SQL/XML, and XML Mapping!

Go to Conference:

Log In Options Username: Password:

Site Map | Privacy Policy | Terms of Use | Trademarks

Stylus Studio® and DataDirect XQuery ™are from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2016 All Rights Reserved.