[ 7 et 14 derniers jours ] [ Pays - Régions ]
#LSDateFormat(DateAutoCreation,'dddd')# :: #LSDateFormat(DateAutoCreation,'dd.mm.yyyy')#
#Trim(TitreClip)#
(#Trim(Ref)#)
#URLdeRef#
#ParagraphFormat(Clip)#
#ParagraphFormat(Chapo)# [suite...]
(#Trim(NomEnvoyeur)#)
")#>
Envoyer à un(e) ami(e) | Commentaires
#LSDateFormat(DateAutoCreation,'dddd')# :: #LSDateFormat(DateAutoCreation,'dd.mm.yyyy')#
#TitreClip#
#resume# [suite...] (#Trim(NomEnvoyeur)#)
|
|
SELECT TOP 1 HeureCreation FROM infos
WHERE HeureCreation < NOW()
AND Publiable = 1
ORDER BY HeureCreation DESC
|
Entrevues
|
SELECT TOP 3 HeureCreation, NumeroFiche, TitreClip
FROM infos
WHERE
(NOW() - HeureCreation) > 0
AND Publiable = 1
AND ClassType LIKE 'Entrevue'
ORDER BY HeureCreation DESC
 |
#TitreClip# [#LSDateFormat(HeureCreation,'dd/mm/yy')#]
|
|
Dossiers
|
SELECT TOP 3 HeureCreation, NumeroFiche, TitreClip FROM infos
WHERE
(NOW() - HeureCreation) > 0
AND Publiable = 1
AND ClassType LIKE 'Dossier'
ORDER BY HeureCreation DESC
|
#TitreClip# [#LSDateFormat(HeureCreation,'dd/mm/yy')#]
|
|
Communiqués de presse
|
SELECT TOP 3 HeureCreation, NumeroFiche, TitreClip FROM infos
WHERE
(NOW() - HeureCreation) > 0
AND Publiable = 1
AND ClassType LIKE 'Com.Presse'
ORDER BY HeureCreation DESC
|
#TitreClip# [#LSDateFormat(HeureCreation,'dd/mm/yy')#]
|
|
Agenda
[ Futur ] [ Passé ] [ Compte-rendus ]
| |