I don't recall but trust your saying you've determined JET
does not provide
native support for the RFC-822 format which you correctly
surmise is the
only format proven to be supported by the majority of
aggregators. Your
current date is non-compliant.
The best solution is to upsize to SQL Server which provides
native support
for RFC-822. Meanwhile, you do not need an RFC-822 compliant
data type per
se so use a text data type and build compliance using your
server-side code.
You also want to know about the Advisory Board website [1]
<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
URL
http://clintongallagher.metromilwaukee.com/
[1]
http://www.rssboard.org/rss-specification
"Bob" <no@mail.com> wrote in message
news:f588ej$3i3$1@forums.macromedia.com...
> I've set up an rss feed using the example on
>
http://www.geekpedia.com/tutorial157_Create-an-RSS-feed-using-ASP.NET-2.0.html
>
> However I use MS Access db and I would like to have the
right date format
> which I belive is RFC-822.
>
> I'm in Europe and currently my date output looks like
this
> <pubDate>18-06-2007 20:51:19</pubDate>
>
> <asp:AccessDataSource ID="AccessDataSource1"
runat="server"
> DataFile="d:\web\database\news.mdb"
> DataSourceMode="DataReader" SelectCommand="SELECT
storyDate,
> Title,
> Short, ArticleID FROM news ORDER BY storyDate DESC">
> </asp:AccessDataSource>
>
> Can anyone help me out with how I go by doing this?
>
> Thanks
> Bob
>
>
>
>
1
Reply
AdChoices