Re: Counting items related by a linked list

Why post the problem again? You probably missed the solution I posted two
days ago...

Cheers,

Dimitre Novatchev,
FXSL developer,

http://fxsl.sourceforge.net/ -- the home of FXSL
Resume: http://fxsl.sf.net/DNovatchev/Resume/Res.html


"Joe K" <anotherquestion@xxxxxxxxxxx> wrote in message
news:BAY8-F85AiPgTN4tNNn00003eb8@xxxxxxxxxxxxxx
> 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
>
>



__________________________________
Do you Yahoo!?
Yahoo! Finance Tax Center - File online. File on time.
http://taxes.yahoo.com/filing.html