SELECT sections_pages.Id, sections_pages.web,sections_pages.Date, sections_pages.Description, sections_pages.Extrait, sections_pages.Categorie_No, sections_pages.Titre, sections_pages.Titre2, sections_pages.Sequence_No, sections_pages.niveau, sections_pages.Nature,sections_pages.modification, sections_pages.niveau3, sections_pages.Repertoire_No, sections_pages.DB_Source, sections_pages.auteur, Fiches.Web as webpath, Fiches.Societe, Fiches.Nom, Fiches.Prenom FROM sections_pages LEFT JOIN Fiches ON Fiches.Repertoire_No = sections_pages.Repertoire_No WHERE #PreserveSingleQuotes(ActifQuery)##PreserveSingleQuotes(DBQuery)##PreserveSingleQuotes(GlobalQuery)##PreserveSingleQuotes(LieuQuery)##PreserveSingleQuotes(SecteurQuery)##PreserveSingleQuotes(naturequery)#sections_pages.Langue LIKE '%fr%' AND sections_pages.entree <= #CreateODBCDate("#now()#")# AND sections_pages.expiration >= #CreateODBCDate("#now()#")##PreserveSingleQuotes(SrchtypeQuery)# ORDER BY sections_pages.clic desc,sections_pages.Titre,sections_pages.Titre2

Rubriques du site

Programmeur
WHERE #PreserveSingleQuotes(ActifQuery)##PreserveSingleQuotes(DBQuery)##PreserveSingleQuotes(GlobalQuery)##PreserveSingleQuotes(LieuQuery)##PreserveSingleQuotes(SecteurQuery)##PreserveSingleQuotes(naturequery)#sections_pages.Langue LIKE '%fr%' AND sections_pages.entree <= #CreateODBCDate("#now()#")# AND sections_pages.expiration >= #CreateODBCDate("#now()#")##PreserveSingleQuotes(SrchtypeQuery)#
#sections_pages.RecordCount# éléments trouvés élément trouvé
#DateFormat(modification,'yyyy-mm-dd')#  [#Id#] ">#Replace("#Titre2#", "<[^>]*>", "", "ALL")##Replace("#Titre#", "<[^>]*>", "", "ALL")#Voir cette publication
#Extrait#
Auteur : #auteur#
1#Var.StartNavM#">Précédent | Suivant