| Author |
 Topic Search  Topic Options
|
dpyers 
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
 Post Options
 Thanks(0)
 Quote  Reply
 Posted: 20 October 2009 at 3:34pm |
|
Just to exclude rss.asp as the problem, try incrementing a counter (i = 1 + 1) just before the set rs = nothing and then write out the counter after you set rs = nothing (response.write "<p>Count = " & i & "</p>"
Run just rss.asp in your browser and see what the counter says. If you don't see the counter, you've hit the http size limitation.
If the counter says 1000, then it's some limitation on what you can return from access via the ado on the web. There's ways to use the ado.command object to page through the db and return blocks of rows/data at a time.
If the counter says 1500, then it's an issue on the xml/rss side. RSS 0.90-.092 had some limitations on title and descriptions - 500 characters, and a limit of 100 characters on links. You may want to try rss 1.0 or 2.0.
Other than that, I'm about tapped out.
|
Lead me not into temptation... I know the short cut, follow me.
|
 |
WebWiz-Bruce
Admin Group
Web Wiz Developer
Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 October 2009 at 3:42pm |
|
That reminds me there is a 100Kb limit on the ASP response object. So you can only out put pages that are less than 100Kb as this also includes any headers, cookies, etc. set by your website.
|
|
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 20 October 2009 at 4:22pm |
 WebWiz-Bruce wrote:
That reminds me there is a 100Kb limit on the ASP response object. So you can only out put pages that are less than 100Kb as this also includes any headers, cookies, etc. set by your website.
|
That's what I was thinking about when I said http limit of 100K. Must be getting senile - again!
|
Lead me not into temptation... I know the short cut, follow me.
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 26 October 2009 at 8:02pm |
|
kennywhite, did you ever figure this out?
|
Lead me not into temptation... I know the short cut, follow me.
|
|
kennywhite
Groupie
Joined: 26 February 2009
Location: Indy
Status: Offline
Points: 106
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 October 2009 at 3:42pm |
No. I haven't figured it out yet. I've posted the same question on other forums, but no one is ever as helpful as the folks here.
The person who set up this feed http://pulssr.com/rss/0.rss said that they tested it out with over 1000 entries and they had no problems, but I didn't get a response when asking for source code.
Any new ideas? :D
|
|
dpyers
Senior Member
Joined: 12 May 2003
Status: Offline
Points: 3937
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 October 2009 at 6:05pm |
|
Nope. Was hoping you had discovered something.
Did you try Bruce's suggestion to set it up as an atom feed?
|
Lead me not into temptation... I know the short cut, follow me.
|
|
kennywhite
Groupie
Joined: 26 February 2009
Location: Indy
Status: Offline
Points: 106
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 October 2009 at 7:37pm |
|
I have no tried that yet. I wanted to try to find a solution with RSS before I move on.
|
|
kennywhite
Groupie
Joined: 26 February 2009
Location: Indy
Status: Offline
Points: 106
|
Post Options
Thanks(0)
Quote Reply
Posted: 27 October 2009 at 7:53pm |
I did, however, try spitting out every entry into an asp page and it will display all 1,500 or so with no problem.
It has to be a problem with RSS/XML. The versions of both of them that are documented in the code is a bit older. Is there a good site that may show the differences of the syntax in the different versions?
|
|
