I'm facing a issue in AMPScript. I need to manipulate an XML feed. This is what it looks like :
<articles>
<article>
<title>Lorem Ipsum</title>
<short_title>Lorem</short_title>
<description>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed scelerisque metus sit amet tempus posuere. Phasellus pulvinar, libero vel ultricies sodales</description>
<link>http://www.mylink.com</link>
<taxonomy_menu1>
<taxonomy_param>mySpe1</taxonomy_param>
<taxonomy_param>mySpe2</taxonomy_param>
<taxonomy_param>mySpe3</taxonomy_param>
</taxonomy_menu1>
</article>
<article>
<title>Lorem Ipsum</title>
<short_title>Lorem</short_title>
<description>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed scelerisque metus sit amet tempus posuere. Phasellus pulvinar, libero vel ultricies sodales</description>
<link>http://www.mylink.com</link>
<taxonomy_menu1>
<taxonomy_param>mySpe1</taxonomy_param>
<taxonomy_param>mySpe2</taxonomy_param>
<taxonomy_param>mySpe3</taxonomy_param>
</taxonomy_menu1>
</article>
<article>
<title>Lorem Ipsum</title>
<short_title>Lorem</short_title>
<description>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Sed scelerisque metus sit amet tempus posuere. Phasellus pulvinar, libero vel ultricies sodales</description>
<link>http://www.mylink.com</link>
<taxonomy_menu1>
<taxonomy_param>mySpe1</taxonomy_param>
<taxonomy_param>mySpe2</taxonomy_param>
<taxonomy_param>mySpe3</taxonomy_param>
</taxonomy_menu1>
</article>
Here is my question : How can I have the count of taxonomy_param in each article ?
I know how to manipulate and display basics informations like here, the short_title or description, by using the classics BuildRowsetFromXML and Field(Row(@titles,1),"Value"). But in this configuration I'm stuck.
If I want to display the count of taxonomy_param, I'll get 9. That's correct. But later, I'll have to loop inside of each taxonomy_param, of each taxonomy_menu1 of each article to display what I want.
I hope it's clear :)
Thanks in advance !