[ic] RSS feeds with IC

[Joshua Lavin <suppressed>]

Hey everyone,

This is something new I'm trying, and I thought it'd be fun to share. I 
wanted to get an RSS feed of what's new on our site, but this could be 
used for any list.

I created a new page in [catroot]/pages, called 'rss.xml.html', with 
the code below (although I don't think it needs the second line). It is 
pulled up without the html extension, so 
http://shopalert.us/shop/rss.xml gets the feed. (Note that some fields 
here are not IC defaults.)

[set mv_add_do_html]0[/set]
[calc] $Config->{HTMLsuffix} = '.xml'; return[/calc]
[tag op=header]Content-type: text/xml[/tag]
<?xml version="1.0" ?>
<rss version="2.0">

<channel>
    <title>ShopALERT What's New</title>
    <link>http://www.shopalert.us/shop/whatsnew.html</link>
    <description>ShopALERT: Newest Items Added</description>
    <language>en</language>
    <copyright>Copyright 2004 ALERT</copyright>
    <lastBuildDate>[time]%a, %d %b %Y %H:%M:%S %Z[/time]</lastBuildDate>
    <generator>Interchange</generator>
    <webMaster>suppressed</webMaster>

    [query sql="select SKUID, FullDescription, Department, Category, 
RetailPrice, SKUPicText from products order by SKUID desc limit 15" 
table=products type=list]
    [list]
    <item>
        <title>[sql-field FullDescription]</title>
        <link>http://www.shopalert.us/shop/[sql-code].html</link>
        <description><![CDATA[<strong>[sql-field Department]: 
[sql-field Category]</strong><br /><br />
        [sql-field SKUPicText]<br /><br />
        [sql-price]]]></description>
    </item>
    [/list]
    [/query]
</channel>
</rss>

Enjoy!

--
Josh Lavin
Kingdom Design   http://www.kdw.us/

_______________________________________________
interchange-users mailing list
suppressed
http://www.icdevgroup.org/mailman/listinfo/interchange-users