SELECT Id,repertoire_no,niveau,titre,actif,attachement,attribut,description,extrait,niveau1,niveau2,niveau3,niveau5,url,bouton_off,bouton_on,photo,photo_mini,photo_texte,classement,entree,modification,intranet_statut FROM Sections WHERE #PreserveSingleQuotes(QryMenuactif)##PreserveSingleQuotes(EntreeQuery)##PreserveSingleQuotes(ExpirationQuery)#Repertoire_No=#attributes.Repertoire_No# ORDER BY Niveau1,Tri, Titre SELECT id,repertoire_no,categorie_no,sequence_no,niveau,titre,actif,attachement,description,extrait,niveau5,web,classement,target,intranet_statut,categorie_no FROM Sections_Pages WHERE #PreserveSingleQuotes(ActifQuery)##PreserveSingleQuotes(EntreeQuery)##PreserveSingleQuotes(ExpirationQuery)#Repertoire_No=#attributes.Repertoire_No# AND Niveau='1' ORDER BY Tri, Titre SELECT id,repertoire_no,categorie_no,sequence_no,niveau,titre,actif,attachement,description,extrait,niveau5,web,intranet_statut FROM Sections_Pages WHERE #PreserveSingleQuotes(ActifQuery)##PreserveSingleQuotes(EntreeQuery)##PreserveSingleQuotes(ExpirationQuery)#Repertoire_No=#attributes.Repertoire_No# AND Niveau='2' ORDER BY Tri, Titre SELECT Id,Repertoire_No,Categorie_No,Sequence_No,Niveau,Titre,Actif,Attachement,Description,Extrait,Niveau5,Web FROM Sections_Pages WHERE #PreserveSingleQuotes(ActifQuery)##PreserveSingleQuotes(EntreeQuery)##PreserveSingleQuotes(ExpirationQuery)#Repertoire_No=#attributes.Repertoire_No# AND Niveau='3' ORDER BY Tri, Titre SELECT id,repertoire_no,niveau,niveau2,niveau3,titre,titre2,actif,codehaut,attachement,description,extrait,url,attribut,banniere,banniere_texte,photo,photo_mini,photo_texte,background,codehaut,intranet_statut,clic,codehaut FROM Sections WHERE IdenId=#attributes.M# AND Repertoire_No=#attributes.Repertoire_No# UPDATE Sections SET clic = Clic + 1 WHERE Id=#attributes.M# SELECT id,categorie_no,titre,banniere,banniere_texte,background,codehaut,niveau2,niveau3,web FROM Sections_Pages WHERE #PreserveSingleQuotes(ActifQuery)##PreserveSingleQuotes(EntreeQuery)#IdenId=#attributes.id# AND Categorie_No=#attributes.M# AND Repertoire_No=#attributes.Repertoire_No# UPDATE Sections_Pages SET clic = Clic + 1 WHERE Id=#attributes.id#