SELECT Divers17_t,Divers17,Service_t,Services,Realisations_t,Realisations
FROM Fiches
WHERE Repertoire_No=#attributes.Repertoire_No#
SELECT Id,Titre,Description
FROM Activites
WHERE Option='2' and Repertoire_No=#attributes.Repertoire_No# and Categorie_No=#attributes.Categorie_No# AND (Actif='3' or Actif='1')
ORDER BY Titre
Call for Tenders
Contest
Forums
Training
#Fiches.Divers17_t#
#replace("#REReplace("#REReplace("#Fiches.Divers17#","([[: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")#
Products
#replace("#REReplace("#REReplace("#Fiches.Service_t#","([[: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")#
Programming
Portfolio
Projects
Proposals
Achievements
#Fiches.Realisations_t#
#replace("#REReplace("#REReplace("#Fiches.Realisations#","([[: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")#
Meetings
Services
#replace("#REReplace("#REReplace("#Fiches.Services#","([[: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")#
Others
- #Titre#
- #Left(Description,150)#...