Forum Moderators: open
The design suggest by XMLMania did work, and has run smoothly for a while. I just happened to check my feeds lately and there is a strange error:
XML Parsing Error: not well-formed
Location: http://www.example.com/feed.asp
Line Number 13, Column 26: <font face="Arial" size=2>
--------------------------------------------------^
The problem is that the '2' is missing quotes. Simple enough, right? Just CDATA the description tag or whatever is coming out of my DB that contains the 'poorly formed' html.
Not so simple: this specific '<font face="Arial" size=2>' does not exist in my db anywhere. I have double checked this (besides I never use that font style ;).
So the question is where is this badly formed tag coming from? And why would the feed work fine and then display this..? I am stumped!
The full code of this feed generator is in XMLMania's message in the previously mentioned thread. Any help would be appreciated!
Guessing ....... your DB content has HTML in it and your not doing a full escape on it?
I'd search the DB again .......
<?xml version="1.0" encoding="iso-8859-1"?>
<!DOCTYPE rss PUBLIC "-//Netscape Communications//DTD RSS 0.91//EN" "http://my.netscape.com/publish/formats/rss-0.91.dtd">
<rss version="0.91">
<channel>
<title>Example.com - Inventory Channel</title>
<link>http://www.example.com</link>
<description>Example.com Inventory</description>
<language>en</language>
<image>
<title>Example.com</title>
<url>http://www.example.com/logo.gif</url><link>http://www.example.com/link>
</image>
<font face="Arial" size=2>
<p>Microsoft VBScript runtime </font> <font face="Arial" size=2>error '800a01a8'</font>
<p>
<font face="Arial" size=2>Object required: ''</font>
<p>
<font face="Arial" size=2>/inventory.asp</font><font face="Arial" size=2>, line 78</font>
My SQL statement is broken I guess, not the feed. The thing is, I'm looking at the DB right now and all the columns are definitely present in the query I'm requesting.. what could this '' required object be?
Should that have parentheses?
