How can i query a list to get the number of one particular item in it ....for example, i have this list
title,link,description,language,webMaster,lastBuildDate,item,item2,item3,item4,item5,item6
and i want to know how many of itemx there are, so in this list item would appear 6 times and i wwould need to run my loop to parse XML 6 times...thanks
If there is someway to do
select count(1) from THELIST where XML.RSS.CHANNEL.CHILD_LIST like 'item%'
title,link,description,language,webMaster,lastBuildDate,item,item2,item3,item4,item5,item6
and i want to know how many of itemx there are, so in this list item would appear 6 times and i wwould need to run my loop to parse XML 6 times...thanks
If there is someway to do
select count(1) from THELIST where XML.RSS.CHANNEL.CHILD_LIST like 'item%'
