Limiting Output of RSS Feed

[HMOKeefe]

I am pulling an RSS feed into an intranet and have not figured out how to
restrict the output to the 10 most recent news items. I know I can do a TOP 10
or something similar from my own database, but how do I do this with an RSS
feed? Here is the code:

<cfhttp url="http://www.nih.gov/news/feed.xml"/> <cfset rss =
XMLParse(cfhttp.filecontent)>
<!--- get an array of items --->
<cfset items = XMLSearch(rss, "/rss/channel/item")>
<cfset channel = XMLSearch(rss, "/rss/channel")>
<cfset rssItems = QueryNew("title,description,link")>
<!--- loop through the array of items --->
<cfloop from="1" to="#ArrayLen(items)#" index="i">
<cfset row = QueryAddRow(rssItems)>
<cfset title = XMLSearch(rss, "/rss/channel/item[#i#]/title")>
<cfif ArrayLen(title)> <cfset title = title[1].xmlText>
<cfelse>
<cfset title="">
</cfif>
<cfset description = XMLSearch(items, "/rss/channel/item[#i#]/description")>

<cfif ArrayLen(description)>
<cfset description = description[1].xmlText>
<cfelse>
<cfset description="">
</cfif>
<cfset link = XMLSearch(items, "/rss/channel/item[#i#]/link")>
<cfif ArrayLen(link)>
<cfset link = link[1].xmlText>
<cfelse>
<cfset link="">
</cfif>
<!--- add to query --->
<cfset QuerySetCell(rssItems, "title", title, row)>
<cfset QuerySetCell(rssItems, "description", description, row)>
<cfset QuerySetCell(rssItems, "link", link, row)>
</cfloop>
<cfset chtitle = XMLSearch(rss, "/rss/channel/title")>
<cfif ArrayLen(chtitle)>
<cfset ctitle = chtitle[1].xmlText>
<cfelse>
<cfset ctitle="">
</cfif>
<cfset chdate = XMLSearch(rss, "/rss/channel/pubDate")>
<cfif ArrayLen(chdate)>
<cfset date = chdate[1].xmlText>
<cfelse>
<cfset date="">
</cfif>
<cfset img = XMLSearch(rss, "/rss/channel/image/url")>
<cfif ArrayLen(img)>
<cfset imgurl = img[1].xmlText>
<cfelse>
<cfset imgurl="">
</cfif>
<cfoutput> <table cellpadding="5" cellspacing="1">
<tr><td><strong> #ctitle# | #date# </strong></td></tr>
</cfoutput>
<cfoutput query="rssItems">
<tr><td><b><a href="#rssItems.link#">#rssItems.title#</a></b> -
#rssItems.description#</td></tr>
</cfoutput>
</table>

[philh]

Supposing that the items array is in descending date/time order, try
<cfif arraylen(items) GT 10>
<cfloop from="1" to="10" index="i">
<cfelse>
<cfloop from="1" to="#ArrayLen(items)#" index="i">
</cfif>

HTH,

[philh]

Oops, sorry; didn't see the rss output loop at the bottom. Try

<cfoutput query="rssItems" maxrows="10">

[HMOKeefe]

This is great. Works fine now. Thanks!