Counting items related by a linked list

Play the video

Subject: Counting items related by a linked list
From: "Joe K" <anotherquestion@xxxxxxxxxxx>
Date: Wed, 24 Mar 2004 09:21:17 -0800

I made a slight error in the original post of this message before. I am making a correction, adding a few additional comments, and am reposting it.

The question: I would like to define a variable such that given the CItem ID, say 1003, I can get a count of all the AItems linked to it.

The answer for example below for CItemID = 2003 would be 3 because:

	<LinkItem>
	  <SourceID>104</SourceID>	BItem - not in count
	  <TargetID>1003</TargetID>
	</LinkItem>
	<LinkItem>
	  <SourceID>6</SourceID>	AItem - in count
	  <TargetID>1003</TargetID>
	</LinkItem>
	<LinkItem>
	  <SourceID>4</SourceID>	AItem - in count
	  <TargetID>1003</TargetID>
	</LinkItem>
	<LinkItem>
	  <SourceID>101</SourceID>	BItem - not in count
	  <TargetID>1003</TargetID>
	</LinkItem>
	<LinkItem>
	  <SourceID>2</SourceID>	AItem - in count
	  <TargetID>1003</TargetID>
	</LinkItem>

I have the following type of xml document: Note: 1) All IDs are unique and can be any positive number 2) The link pairs below can link any item to any different Item. 3) CItems are always in the "Target" portion of the link table, but if AItem and BItem they can be in either position. 4) No item can be linked more than once to another item. This means if there is a: <LinkItem> <SourceID>3</SourceID> <TargetID>101</TargetID> </LinkItem> There cannot be a: <LinkItem> <SourceID>101</SourceID> <TargetID>3</TargetID> </LinkItem>

<TopLevel>

<AItem>
 <ID=1/>
 <Name=/>
</AItem>
<AItem>
 <ID=2/>
 <Name=/>
</AItem>
<AItem>
 <ID=3/>
 <Name=/>
</AItem>
<AItem>
 <ID=4/>
 <Name=/>
</AItem>
<AItem>
 <ID=5/>
 <Name=/>
</AItem>

<BItem>
 <ID=101/>
 <Name=/>
</BItem>
<BItem>
 <ID=102/>
 <Name=/>
</BItem>
<BItem>
 <ID=103/>
 <Name=/>
</BItem>
<BItem>
 <ID=104/>
 <Name=/>
</BItem>
<BItem>
 <ID=105/>
 <Name=/>
</BItem>
<BItem>
 <ID=106/>
 <Name=/>
</BItem>

<CItem>
 <ID=1001/>
 <Name=/>
</CItem>
<CItem>
 <ID=1002/>
 <Name=/>
</CItem>
<CItem>
 <ID=1003/>
 <Name=/>
</CItem>
<CItem>
 <ID=1004/>
 <Name=/>
</CItem>
<CItem>
 <ID=1005/>
 <Name=/>
</CItem>
<CItem>
 <ID=1006/>
 <Name=/>
</CItem>
<CItem>
 <ID=1007/>
 <Name=/>
</CItem>


<LinkItem>
 <SourceID>104</SourceID>
 <TargetID>1001</TargetID>
</LinkItem>
<LinkItem>
 <SourceID>104</SourceID>
 <TargetID>1003</TargetID>
</LinkItem>
<LinkItem>
 <SourceID>6</SourceID>
 <TargetID>1003</TargetID>
</LinkItem>
<LinkItem>
 <SourceID>105</SourceID>
 <TargetID>1002</TargetID>
</LinkItem>
<LinkItem>
 <SourceID>3</SourceID>
 <TargetID>101</TargetID>
</LinkItem>
<LinkItem>
 <SourceID>4</SourceID>
 <TargetID>1003</TargetID>
</LinkItem>
<LinkItem>
 <SourceID>102</SourceID>
 <TargetID>1</TargetID>
</LinkItem>
<LinkItem>
 <SourceID>101</SourceID>
 <TargetID>1003</TargetID>
</LinkItem>
<LinkItem>
 <SourceID>2</SourceID>
 <TargetID>1003</TargetID>
</LinkItem>

</TopLevel>

_________________________________________________________________ Is your PC infected? Get a FREE online computer virus scan from McAfee. Security. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963

Current Thread
Counting items related by a linked list Joe K - Tue, 23 Mar 2004 00:17:47 -0500 (EST) M. David Peterson - Tue, 23 Mar 2004 03:01:02 -0500 (EST) <Possible follow-ups> Joe K - Wed, 24 Mar 2004 01:36:08 -0500 (EST) Joe K - Wed, 24 Mar 2004 12:33:23 -0500 (EST) <=

<- Previous	Index	Next ->
RE: Counting items related by, Joe K	Thread	How to do... regular 1 to n l, Paul Johnston
RE: xsl:key use attribute usi, Yovanis	Date	RE: xsl:key use attribute usi, Michael Kay
	Month

PURCHASE STYLUS STUDIO ONLINE TODAY!

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

Download The World's Best XML IDE!

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

Subscribe in XML format

RSS 2.0
Atom 0.3

XML Editor - Download a 15 Day Free Trial Now >

See What's New in Stylus Studio >

Buy Stylus Studio - XML Editor - Now >