SELECT entree,Id,sujet,message,Description,web,photo_mini,attachement FROM Nouveautes WHERE Repertoire_No=#attributes.Repertoire_No# AND Actif='3' AND Entree <= #CreateODBCDate("#now()#")# ORDER BY niveau5 desc, Entree desc; SELECT entree,Id,Titre,extrait,Description,web,photo_mini FROM Communiques WHERE Repertoire_No=#attributes.Repertoire_No# AND Actif='3' AND Entree <= #CreateODBCDate("#now()#")# ORDER BY Entree desc, Id desc;

Salle de pressse RSS

BIENTÔT AUTOMATISÉ

Copier-coller le texte ci-après dans une page intitulé - rss.xml et mettre à la racine de votre page Web.

<?xml version="1.0" encoding="utf-8"?> 
<rss version="2.0" xmlns:atom="http://www.w3.org/2005/Atom">
<channel> 
		<cfoutput><title>#getbaseinfo.societe#</title> 
  		<link>http://#replace (getbaseinfo.web,"http://","","all")#</link> 
  		<description>Les nouveautés</description>
  		<language>fr-ca</language>
		<lastBuildDate>#LSDateFormat(Now(),'yyyy-mm-dd')# 12:00:00 CENTER</lastBuildDate> 
		<copyright>Tous droits réservés ©  #getbaseinfo.societe#</copyright> 
		<docs>http://#replace(getbaseinfo.web,"http://","","all")#/rss.xml</docs>
		<atom:link href="http://#replace(getbaseinfo.web,"http://","","all")#/rss.xml" rel="self" type="application/rss+xml" /></cfoutput>
		<cfoutput query="Nouveautes_interne" maxrows="#attributes.NavMaxRows#" startrow=#URL.StartNav#>
         <item> 
            <title>#REReplace("#Nouveautes_interne.Sujet#", "<[^>]*>", "", "ALL")#</title> 
            <link><cfif len(nouveautes_interne.web)>http://#Replace("#URLEncodedFormat("#Nouveautes_interne.Web#")#","http://","","ALL")#<cfelse>http://#replace(getbaseinfo.web,"http://","","all")#/#attributes.FicheBase#?#attributes.URLParam##REReplace("Voir=nouv&Id=#nouveautes_interne.Id#","\&(##?[A-Za-z0-9]*);", "&\1;", "ALL")#</cfif></link> 
            <description><cfif len(nouveautes_interne.message)>#REReplace("#Nouveautes_interne.Message#", "<[^>]*>", "", "ALL")#<cfelse>#REReplace("#Left("#nouveautes_interne.Description#",600)#", "<[^>]*>", "", "ALL")#</cfif></description> 
            <pubDate>#LSDateFormat("#Nouveautes_interne.Entree#","Dddd, dd mmm yyyy")# 00:12:00 CENTER</pubDate>
            <guid isPermalink="true"><cfif len(nouveautes_interne.web)>http://#Replace("#Nouveautes_interne.Web#","http://","","ALL")#<cfelse>http://#replace (getbaseinfo.web,"http://","","all")#/#attributes.FicheBase#?#attributes.URLParam##REReplace("Voir=nouv&Id=#nouveautes_interne.Id#","\&(##?[A-Za-z0-9]*);", "&\1;", "ALL")#</cfif></guid> 
        </item> 
		</cfoutput>
		<cfoutput query="communique_interne" maxrows="#attributes.NavMaxRows#" startrow=#URL.StartNav#>
         <item> 
            <title>Communiqué - #REReplace("#communique_interne.titre#", "<[^>]*>", "", "ALL")#</title> 
            <link><cfif len(communique_interne.web)>http://#Replace("#communique_interne.Web#","http://","","ALL")#<cfelse>http://#replace (getbaseinfo.web,"http://","","all")#/#attributes.FicheBase#?#attributes.URLParam##REReplace("Voir=comm&Id=#communique_interne.Id#","\&(##?[A-Za-z0-9]*);", "&\1;", "ALL")#</cfif></link> 
            <description><cfif len(communique_interne.description)>#REReplace("#Left("#communique_interne.Description#",600)#", "<[^>]*>", "", "ALL")#</cfif></description> 
            <pubDate>#LSDateFormat("#communique_interne.Entree#","Dddd, dd mmm yyyy")# 12:00:00 CENTER</pubDate>
            <guid isPermalink="true"><cfif len(communique_interne.web)>http://#Replace("#URLEncodedFormat("#communique_interne.Web#")#","http://","","ALL")#<cfelse>http://#replace(getbaseinfo.web,"http://","","all")#/#attributes.FicheBase#?#attributes.URLParam##REReplace("Voir=comm&Id=#communique_interne.Id#","\&(##?[A-Za-z0-9]*);", "&\1;", "ALL")#</cfif></guid> 
        </item> 
		</cfoutput>
    </channel> 
</rss>