Re: Getting to xsl:template to match only nodes with a certain attribute - XML / XSL Discussion Boards

Nick Parker25-Jul-03 7:04

25-Jul-03 7:04

You can use XPath to contruct a query, then depending on what language you are using to implement this you could (C# exmample):

public XmlNodeList Search(string input)
{
  string query = "/mainnode/subnode/[name = " + input.Trim().ToString() + "]";
  XmlDocument doc = new XmlDocument();
  doc.Load("mydata.xml");
  XmlNodeList nodes = doc.SelectNodes(query);
  return nodes;
}

Then just iterate through your return XmlNodeList 5 times. I suppose there are other ways to do this, this is just a quick example.

-Nick Parker

Re: Select top 5 "rows" in XML -file

Philip Patrick26-Jul-03 21:26

Philip Patrick

26-Jul-03 21:26

Yep, the "pure" xsl solution will be using position() I believe, like this:

"/store/books[position() <= 5]"

This will select 5 first books

Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer

Accessing an XML sequence

Bernhard Hofmann23-Jul-03 0:24

Bernhard Hofmann

23-Jul-03 0:24

Hi
I'm trying to access a sequence which is part of a node in an XML file.

<br />
  <property pr_ref="ABC" ... ><br />
    <sellingpoint text="HALLWAY" /><br />
    <sellingpoint text="DINING ROOM" /><br />
    <sellingpoint text="KITCHEN" /><br />
  </property><br />

I can iterate through the "property" nodes and retrieve their columns (pr_ref) but how on earth do I access the sequence of selling points? I've tried childrows and parents rows and I'm lost!

I'm using VB.NET and I have the entire file in a DataSet. The second table of the dataset seems to contain ALL of the sellingpoint rows, not just those related to the one property. Confused | :confused:

I'm desperate!
Bernhard

Don't worry, nobody lives forever.

Re: Accessing an XML sequence

Philip Patrick26-Jul-03 21:22

Philip Patrick

26-Jul-03 21:22

Well, if you have created the class for handling your dataset (Generate code or something), then you should be able to use a function of propertyRow, which named like GetSellingpointRows().
If you don't see it, then you can try using GetChildRows anyway. I can't help you much with VB, but here is a link to IBuySpy[^]. You can download a VB version and see how they did this (look in PortalCfg.vb and Components/Configuration.vb):

Philip Patrick
Web-site: www.stpworks.com
"Two beer or not two beer?" Shakesbeer

Populating Treeview Control with XML Explicit

djoy22-Jul-03 16:43

djoy

22-Jul-03 16:43

Not sure this is the right forum but I have a problem generating XML for my IE Treeview Web control. With XML Explicit I get a long XML string that truncates returned data before generating the next line of code. I can only assume it's exceeded the 255 char record limit for SQL Server 2000 and is truncating data. The example in CODE PROJECT doesn't seem to address this because their sample of data is small. Any ideas? Thanks.

Visulisations

Davy Mitchell22-Jul-03 7:59

Davy Mitchell

22-Jul-03 7:59

Does anyone know of software to create visualisations from any XML file?

Thanks,

Davy

My Personal Blog - Homepage.
Scottish News - Angus Blog, Perth Blog and Dundee Blog

Getting to xsl:template to match only nodes with a certain attribute

Taka Muraoka22-Jul-03 3:22

Taka Muraoka

22-Jul-03 3:22

I have a rule that looks like this:

<xsl:template match="item" >
<item>
<xsl:apply-templates />
</item>
</xsl:template>

This matches all <item> nodes in my source document. However, the source document contains <item xsi:type="ns:AAA"> and <item xsi:type="ns:BBB"> nodes.

I want only the AAA nodes to be picked up. Any ideas...?

"Sucks less" isn't progress - Kent Beck [^]

Awasu 1.1 [^]: A free RSS reader with support for Code Project.

Re: Getting to xsl:template to match only nodes with a certain attribute

Mark Smithson22-Jul-03 3:50

Mark Smithson

22-Jul-03 3:50

Have you tried item[@xsi:type='ns:AAA'] as the match attribute?

Re: Getting to xsl:template to match only nodes with a certain attribute

Taka Muraoka22-Jul-03 3:57

Taka Muraoka

22-Jul-03 3:57

Worked like a charm!

Thanks Smile | :)

"Sucks less" isn't progress - Kent Beck [^]

Awasu 1.1 [^]: A free RSS reader with support for Code Project.

<![CDATA

Hesham Amin21-Jul-03 21:39

Hesham Amin

21-Jul-03 21:39

Hi..
I exported an access 2000 table to XML file
in some elements appears:
<Title>myDataHere</Title>

in some elements appears:
<Title>
<![CDATA[myDataHere]]>
</Title>

what does CDATA do ?
what if I ommit it ?
note than in cases that CDATA appears myDataHere includes (") or (..)

Re: <![CDATA

ZoogieZork22-Jul-03 0:46

ZoogieZork

22-Jul-03 0:46

CDATA specifies a chunk of raw character data, terminated by ]]>. This allows you to embed data with characters with special meaning in XML (namely, <, >, &, and ") without escaping them.

More info (straight from the XML spec):
http://www.w3.org/TR/REC-xml#sec-cdata-sect[^]

- Mike

Re: <![CDATA

Tom Archer22-Jul-03 10:24

Tom Archer

22-Jul-03 10:24

CDATA is simply data that will not be parsed when read. For example, I have an XML help file that contains code snippets for common programming tasks. Since a lot of the characters in the code would violate XML rules and I don't want the format touched. I enter that data into my file as CDATA-type nodes.

Cheers,
Tom Archer
Inside C#,
Extending MFC Applications with the .NET Framework
It's better to listen to others than to speak, because I already know what I'm going to say anyway. - friend of Jörgen Sigvardsson

Re: <![CDATA

J. Dunlap22-Jul-03 10:42

J. Dunlap

22-Jul-03 10:42

I didn't know about this. Helpful! Smile | :)

"Blessed are the peacemakers, for they shall be called sons of God." - Jesus

"You must be the change you wish to see in the world." - Mahatma Gandhi

Re: <![CDATA

Tom Archer22-Jul-03 11:06

Tom Archer

22-Jul-03 11:06

Coolbeans. I'm glad I could you also.

By the way, great sig! Funny how words like that can mean different things to you depending on what you're currently going through in life.

Cheers,
Tom Archer
Inside C#,
Extending MFC Applications with the .NET Framework
It's better to listen to others than to speak, because I already know what I'm going to say anyway. - friend of Jörgen Sigvardsson

Re: <![CDATA

J. Dunlap22-Jul-03 21:27

J. Dunlap

22-Jul-03 21:27

Tom Archer wrote:
By the way, great sig!

Big Grin | :-D

Tom Archer wrote:
Funny how words like that can mean different things to you depending on what you're currently going through in life.

True. Smile | :)

"Blessed are the peacemakers, for they shall be called sons of God." - Jesus

"You must be the change you wish to see in the world." - Mahatma Gandhi

Re: <![CDATA

Hesham Amin22-Jul-03 21:08

Hesham Amin

22-Jul-03 21:08

Thank you all Smile | :)

XML Text access

Steve Severance16-Jul-03 9:57

Steve Severance

16-Jul-03 9:57

I need to access the value of a node that also contains childnodes such as
<node>
text
<child>value</child>
</node>

Inner text doesn't work because I get the child text also. I think that the way Innertext is done is pretty bad. Any Ideas? Thanks.
Steve

Steve

Not all who wander are lost...

Re: XML Text access

Retsof Nawor16-Jul-03 10:14

Retsof Nawor

16-Jul-03 10:14

You can just iterate through the children (IXMLDOMNodeList) checking the type (IXMLDOMNode::nodeType), if it is a text node (NODE_TEXT) append the value to your string otherwise keep iterating...

Re: XML Text access

Steve Severance16-Jul-03 10:40

Steve Severance

16-Jul-03 10:40

Thanks. Will this also work on .NET?

Steve

Not all who wander are lost...

Re: XML Text access

Retsof Nawor16-Jul-03 10:48

Retsof Nawor

16-Jul-03 10:48

Sure, it'll work with any DOM/Language, just the interface/method/constants names may vary slightly...

Re: XML Text access

Tom Archer20-Jul-03 8:07

Tom Archer

20-Jul-03 8:07

If you're using the .NET XML classes, then use XmlNode::ReadElementString.

Cheers,
Tom Archer
Inside C#,
Extending MFC Applications with the .NET Framework
It's better to listen to others than to speak, because I already know what I'm going to say anyway. - friend of Jörgen Sigvardsson

Characters coding problem: DOM, charset, BSTR and Oracle DB

robin39915-Jul-03 1:23

robin399

15-Jul-03 1:23

I'd like to store some data from an XML file to an Oracle Database but there is a problem with several czech characters that are not stored (interpreted, shown?) properly in the database.

The way: XML file (UTF-8 charset, czech characters put into document by using XMLSpy) --> MS-VS6, SP5 C++ program (MSXML 4, import <msxml4.dll> raw_interfaces_only) --> DOM(load method, firstChild->get_text(BSTR)) --> BSTR variable --> wchar_t* --> SQLExecDirectW --> connection string including switch to enable forcing SQLWCHARs --> Oracle DB (using Oracle Driver 9.2., CZECH_CZECH REPUBLIC.EE8ISO8859P2 in registry, all Homes) --> displayed in Toad (Arial, Central European). Some characters are replaced by similar ones, some of them can't be recognized.

Please, help!

Re: Characters coding problem: DOM, charset, BSTR and Oracle DB

robin39915-Jul-03 4:35

robin399

15-Jul-03 4:35

I see now, that Excel is showing the data properly. Toad doesn't...

Generate XML from Schema

Member 47322214-Jul-03 10:57

Member 473222

14-Jul-03 10:57

Can anyone tell me how generate a sample XML instance from a XSD file.

selectSingleNode from a relative position

mcdirge14-Jul-03 7:00

mcdirge

14-Jul-03 7:00

Is there a way to specify a search root to selectSingleNode?

it always gives me the first hit in the file even if the Node that is calling the function is located after the node that gets found.

for example, in file

<forms count="2">
__
____<item>1<\Item>
__
__
____<item>2<\Item>
__

(for some reason the opening Item tags dissapear when i post)

How should I Locate Item 2(In c++) without using child or nextsibling pointers(I cant guarantee the order of the child Items)

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.