SELECT Id,Repertoire_No,Categorie_No,Sequence_No,niveau,Titre,Description,Actif,Attachement
FROM Publications
WHERE #CategorieQuery#Repertoire_No=#attributes.Repertoire_No# AND niveau='1'#PreserveSingleQuotes(IntranetQuery)#
ORDER BY Tri, Titre
SELECT Categorie_No,Id,Titre,Volume,Numero,Extrait,Actif,Attachement
FROM Publications
WHERE #PublicationsQuery#niveau='2' and Repertoire_No=#attributes.Repertoire_No##PreserveSingleQuotes(IntranetQuery)#
ORDER BY Tri, Titre
SELECT Id,Titre,Volume,Numero,Extrait,Actif,Attachement
FROM Publications
WHERE Repertoire_No=#attributes.Repertoire_No# AND niveau='2' AND Categorie_No=999999#PreserveSingleQuotes(IntranetQuery)#
ORDER BY Tri, Titre
Documentation
Publications
Aucune publication de trouvée
#Titre#
#Description#
#Titre#
Volume #replace(Volume,"#chr(13)##chr(10)#","
","all")#
Numéro #replace(Numero,"#chr(13)##chr(10)#","
","all")#
#replace(Publications.Extrait,"#chr(13)##chr(10)#","
","all")#
Divers
#Titre#
Volume #replace(Volume,"#chr(13)##chr(10)#","
","all")#
Numéro #replace(Numero,"#chr(13)##chr(10)#","
","all")#
#replace(Extrait,"#chr(13)##chr(10)#","
","all")#