LDN - Luminis Developer Network

Did you make on progress on this?

Seems like a great idea!

Mario

 Shouldn't be too hard.  Something basic in cfml would look like:

test.cfm

<cfsetting enablecfoutputonly="true">

<cfquery datasource="portaldatabase" name="Talist">

select * from ta_message 

where target_entire_campus = 'Y'

and expirationdate >= some_epoch_time_variable

ORDER BY  TA_MESSAGE.CREATIONDATE DESC, TA_MESSAGE.EXPIRATIONDATE DESC, TA_MESSAGE.DELIVERYDATE DESC

</cfquery>

<cfoutput><?xml version="1.0"?>

<rss version="2.0">

  <channel>

    <title>Announcements</title>

    <link>http://myschool.edu/announce.rss</link>

    <description>Our Schools College Announcements</description>

</cfoutput>

<cfoutput query="talist">

    <item>

       <title>#subject#</title>

       <link>http://mycoldfusionappserver.edu/test2.cfm?messagesubject=#subject#</link>

       <description>#body#</description>

    </item>

</cfoutput>

<cfoutput>

  </channel>

</rss>

</cfoutput>

Links clicked on the above rss feed would then hit test2.cfm and return the body:

<cfif isDefined("messagesubject")>

<cfif messagesubject neq "">

<cfquery datasource="
portaldatabase" name="getmessage">

select body from ta_message 

where subject = '#messagesubject#'

</cfquery>

<cfoutput>#getmessage.body#</cfoutput>

</cfif>

</cfif>