My RSS feed will only display the last 1000 posts on my blog. I've looked through the code multiple times, trying to find the solution. I'm not very savy in ASP, so it wouldn't be surprising if I over looked something simple. Here is my code for rss.asp. <%@LANGUAGE="VBSCRIPT" CODEPAGE="1252"%><!--#include file="config.asp" --><!--#include file="functions.asp" --> <%strURL = "http://serv001/reports/" strSQL = "SELECT * FROM T_WEBLOG WHERE b_published = true ORDER BY b_date DESC, b_time DESC" Set Rs = Server.CreateObject("ADODB.Recordset") Rs.ActiveConnection = strConn Rs.Source = strSQL Rs.CursorType = 0 Rs.CursorLocation = 2 Rs.LockType = 1 Rs.Open() response.ContentType="text/xml" response.write "<?xml version=""1.0"" encoding=""ISO-8859-1""?>" & vbcrlfresponse.Write "<?xml-stylesheet type=""text/xsl"" href=""rss.xsl""?>" & vbcrlfresponse.write "<rss version=""0.91""><channel>" & vbcrlfresponse.write "<title>Ryder Reports RSS feed</title>" & vbcrlfresponse.write "<link>" & strURL & "</link>" & vbcrlf response.write "<description>An RSS feed for Reports</description>" & vbcrlfresponse.write "<language>EN</language>" & vbcrlf if not Rs.EOF Then while not Rs.eof response.write "<item>" & vbcrlf response.write "<title><![CDATA[" & Rs("b_headline") & "]]> </title>" response.write "<category><![CDATA[" & Rs("b_category") & "]]></category>" response.write "<author><![CDATA[Entered by: " & Rs("b_author") & "]]></author>" response.write "<description> <![CDATA[<strong>Requested by:</strong> " & Rs("b_requested") & " <strong>Serial #</strong>" & Rs("b_serial") & " <strong>Location:</strong> " & Rs("b_location") & " <strong>Category:</strong> " & Rs("b_category") & " <strong>Time:</strong> " & Rs("b_minutes") & " Minutes<br>" & Rs("b_content") & "<p> <p> <p> ]]></description>" response.write "<date>" & IntToDate(Rs("b_date")) & "</date>" & vbcrlf response.write "<time>" & Rs("b_time") & "</time>" & vbcrlf response.write "<link>"&strURL&"?view=plink&id="&Rs("id")&"</link>" & vbcrlf response.Write("<id>"&Rs("id")&"</id>") response.write "</item>" & vbcrlf rs.movenextWendend if response.write "</channel></rss>" & vbcrlf rs.closeset rs=nothing%> Code (markup): Here is the code for rss.xsl. It doesn't seem like this page is actually used. Am I wrong there? <?xml version="1.0" encoding="ISO-8859-1"?><xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <html> <head> <title>RSS</title> </head> <body> <ul> <xsl:for-each select="/rss/channel/item"> <li><a href="{link}"><xsl:value-of select="title" /></a> <p><xsl:value-of select="description" /></p> </li> </xsl:for-each> </ul> </body> </html> </xsl:template></xsl:stylesheet> Code (markup): Thanks for looking!
I had forgotten that the database connection isn't shown here since it is in my config.asp include. This is an Access database that I am pulling the information from. I have tried to run the query directly in Access and it displays all of the results. Right now there are about 1500 entries in the database This is an intranet site running on IIS 6.0 from a Windows Server 2003 box. The actual feed size is about 1.14MB. It is always the latest 1000 entries that it diplays. Never any more, never any less and every entry that is displayed appears to be totally intact. Has anyone seen a feed of more than 1000?
When testing out my site's capabilities... I created a feed over 1000 post long... Its not that long anymore, but the channel is pulssr.com/channel?id=0 and the rss feed is at .pulssr.com/rss/0.rss
I see that your site is using php. Mine is using asp. I don't know if that would be the difference there. Could I possibly look at your source code?