SELECT Titre FROM Activites WHERE #PreserveSingleQuotes(ActifQuery)##PreserveSingleQuotes(EntreeQuery)##PreserveSingleQuotes(ExpirationQuery)#Repertoire_No=#attributes.Repertoire_No# AND niveau='1' AND Id=#attributes.Categorie_No# ORDER BY Tri,Titre SELECT Date, Titre, Photo, Photo_mini, Photo_texte, Description, Attachement, Attachement_Poid, Attachement_texte, Envergure, Disponibilite, Partenaires, partenaireid,Echeance, Budget, Realisations, Evaluation, Inventions, Extrait, Exportation, Web, Suggestion, Source, Courriel, Contact, Categorie_No, Sequence_No, Entree, Modification, Langue, Classement, Niveau2, Divers1_t, Divers1, Divers2_t, Divers2, Divers3_t, Divers3, Divers4_t, Divers4, Divers5_t, Divers5, Divers6_t, Divers6, Divers7_t, Divers7, Divers8_t, Divers8, Divers9_t, Divers9, Divers10_t, Divers10, Url1, Url2, Url3, Url4, Url5, Url6, Url7, Url8, Url9, Url10 FROM Activites WHERE #PreserveSingleQuotes(ActifQuery)##PreserveSingleQuotes(EntreeQuery)##PreserveSingleQuotes(ExpirationQuery)#Id=#attributes.Id# ORDER BY Tri,Titre SELECT Id,Categorie_No,Sequence_No,Divers1,Divers1_t,Divers2,Divers2_t, Divers3,Divers3_t,Divers4,Divers4_t,Divers5, Divers5_t,Divers6,Divers6_t,Divers7,Divers7_t, Divers8,Divers8_t,Divers9,Divers9_t,Photo9, Divers10,Divers10_t,Attachement,Attachement_Poid, Attachement_texte,Description,Titre,Photo,Photo_mini,Photo_texte,Extrait,Niveau2 FROM Activites WHERE #PreserveSingleQuotes(ActifQuery)##PreserveSingleQuotes(EntreeQuery)##PreserveSingleQuotes(ExpirationQuery)#Sequence_No=#attributes.Sequence_No# AND niveau='3' ORDER BY Tri,Titre Appel d'offresConcoursForumsFormationProduitsProgrammationPortefolioProjetsPropositionsRéalisationsRencontresServicesDivers#Categorie.Titre#


#Titre#

#replace("#REReplace("#REReplace("#Description#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","ALL")#",chr(10),"
","all")#

Région
#replace (Envergure,chr(10),"
","all")#

Disponibilité
#replace (Disponibilite,chr(10),"
","all")#

Collaboration
#replace("#REReplace("#REReplace("#Partenaires#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","ALL")#",chr(10),"
","all")#

Durée, phases, calendrier de réalisation
#replace (Echeance,chr(10),"
","all")#

BudgetCoût
#replace (Budget,chr(10),"
","all")#

Résultats atteints
#replace (Realisations,chr(10),"
","all")#

Évaluation
#replace (Evaluation,chr(10),"
","all")#

Inventions
#replace (Inventions,chr(10),"
","all")#

Exportation
#replace (Exportation,chr(10),"
","all")#

  • #Titre#
    #replace(Extrait,"#chr(13)##chr(10)#","
    ","all")#

    •

Voir aussi : #Suggestion#

Sources : #Source#
 Courriel : #Courriel#
Date de publication : #Date#

Pour renseignements :

#replace("#REReplace("#REReplace("#Divers1#","([[:space:]])http://([^[:space:]]+?)(\.*[[:space:]])","\1\2\3","ALL")#","([[:space:]])([A-Za-z0-9_\.\-]+@[A-Za-z0-9\.\-]+\.[A-Za-z]{2,})(\.*[[:space:]])","\1\2\3","ALL")#",chr(10),"
","all")#

 

#chr(13)##chr(10)#"> ]*>", "", "ALL")#"">#chr(13)##chr(10)#"> #chr(13)##chr(10)#">#chr(13)##chr(10)#"> #chr(13)##chr(10)#"> #chr(13)##chr(10)#"> #chr(13)##chr(10)#"> #chr(13)##chr(10)#"> #chr(13)##chr(10)#"> #chr(13)##chr(10)#"> ]*>", "", "ALL")#"">#chr(13)##chr(10)#"> #chr(13)##chr(10)#">#chr(13)##chr(10)#"> #chr(13)##chr(10)#"> #chr(13)##chr(10)#">