SELECT Prenom,Nom,Societe,Information,Mission,Realisations,niveau_courriel,Adresse,Ville,Province,Code_postal,Pays, Telephone,Telephone_desc,TelephoneA,TelephoneA_desc,TelephoneB,TelephoneB_desc,TelephoneC,TelephoneC_desc, Telecopieur,Telecopieur_desc,Courriel,Web,Web_anglais,Repertoire_No,Photo,Divers16,Divers18,Projets,Experience,Services,niveau8,repertoire,logo FROM Fiches WHERE Repertoire_No=#URL.Id# ORDER BY Nom; SELECT * FROM Galerie WHERE Repertoire_No=#URL.Id# AND Actif='3' ORDER BY tri,Photo1 desc;

 

#GetFicheInfo.Prenom# #GetFicheInfo.Nom#

#Photo#http://#Replace("#GetFicheInfo.Web#","http://","","ALL")#/images/#GetFicheInfo.Photo#" BORDER="1" ALIGN="right">
http://#Replace("#Getbaseinfo.Web#","http://","","ALL")#/#GetFicheInfo.repertoire#/images/#Galerie.Photo#" border=0 align=top>

Information

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#GetFicheInfo.information#","([[: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")#","\[\[([^\]\]]+?)\]\]","\1","all")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","
","all")#","
","","all")#","

","#chr(13)##chr(10)#

","all")#","


","

#chr(13)##chr(10)#","all")#","


","

#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","
#chr(13)##chr(10)#
","","all")#","
","","all")#","
","","all")#","

    ","
      ","all")#","

    ","
","all")#","

    ","
      ","all")#","

    ","
","all")#","
","
","all")#","
","","all")#","
","","all")#","
","","all")#","
","","all")#

Démarche artistique

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#GetFicheInfo.mission#","([[: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")#","\[\[([^\]\]]+?)\]\]","\1","all")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","
","all")#","
","","all")#","

","#chr(13)##chr(10)#

","all")#","


","

#chr(13)##chr(10)#","all")#","


","

#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","
#chr(13)##chr(10)#
","","all")#","
","","all")#","
","","all")#","

    ","
      ","all")#","

    ","
","all")#","

    ","
      ","all")#","

    ","
","all")#","

","		","all")#","

","		","all")#","

","
","all")#","
","","all")#","
","","all")#","
","","all")#","
","","all")#

Expositions

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#GetFicheInfo.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")#","\[\[([^\]\]]+?)\]\]","\1","all")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","
","all")#","
","","all")#","

","#chr(13)##chr(10)#

","all")#","


","

#chr(13)##chr(10)#","all")#","


","

#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","
#chr(13)##chr(10)#
","","all")#","
","","all")#","
","","all")#","

    ","
      ","all")#","

    ","
","all")#","

    ","
      ","all")#","

    ","
","all")#","

","		","all")#","

","		","all")#","

","
","all")#","
","","all")#","
","","all")#","
","","all")#","
","","all")#

Emplois

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#GetFicheInfo.divers16#","([[: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")#","\[\[([^\]\]]+?)\]\]","\1","all")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","
","all")#","
","","all")#","

","#chr(13)##chr(10)#

","all")#","


","

#chr(13)##chr(10)#","all")#","


","

#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","
#chr(13)##chr(10)#
","","all")#","
","","all")#","
","","all")#","

    ","
      ","all")#","

    ","
","all")#","

    ","
      ","all")#","

    ","
","all")#","

","		","all")#","

","		","all")#","

","
","all")#","
","","all")#","
","","all")#","
","","all")#","
","","all")#

Formation

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#GetFicheInfo.divers18#","([[: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")#","\[\[([^\]\]]+?)\]\]","\1","all")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","
","all")#","
","","all")#","

","#chr(13)##chr(10)#

","all")#","


","

#chr(13)##chr(10)#","all")#","


","

#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","
#chr(13)##chr(10)#
","","all")#","
","","all")#","
","","all")#","

    ","
      ","all")#","

    ","
","all")#","

    ","
      ","all")#","

    ","
","all")#","

","		","all")#","

","		","all")#","

","
","all")#","
","","all")#","
","","all")#","
","","all")#","
","","all")#

Projets

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#GetFicheInfo.projets#","([[: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")#","\[\[([^\]\]]+?)\]\]","\1","all")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","
","all")#","
","","all")#","

","#chr(13)##chr(10)#

","all")#","


","

#chr(13)##chr(10)#","all")#","


","

#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","
#chr(13)##chr(10)#
","","all")#","
","","all")#","
","","all")#","

    ","
      ","all")#","

    ","
","all")#","

    ","
      ","all")#","

    ","
","all")#","

","		","all")#","

","		","all")#","

","
","all")#","
","","all")#","
","","all")#","
","","all")#","
","","all")#

Expériences

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#GetFicheInfo.experience#","([[: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")#","\[\[([^\]\]]+?)\]\]","\1","all")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","
","all")#","
","","all")#","

","#chr(13)##chr(10)#

","all")#","


","

#chr(13)##chr(10)#","all")#","


","

#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","
#chr(13)##chr(10)#
","","all")#","
","","all")#","
","","all")#","

    ","
      ","all")#","

    ","
","all")#","

    ","
      ","all")#","

    ","
","all")#","

","		","all")#","

","		","all")#","

","
","all")#","
","","all")#","
","","all")#","
","","all")#","
","","all")#

Services

#replace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#REReplace("#GetFicheInfo.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")#","\[\[([^\]\]]+?)\]\]","\1","all")#","#chr(13)##chr(10)#","
#chr(13)##chr(10)#","all")#","
","
","all")#","
","","all")#","

","#chr(13)##chr(10)#

","all")#","


","

#chr(13)##chr(10)#","all")#","


","

#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","

","
#chr(13)##chr(10)#","all")#","
#chr(13)##chr(10)#
","","all")#","
","","all")#","
","","all")#","

    ","
      ","all")#","

    ","
","all")#","

    ","
      ","all")#","

    ","
","all")#","

","		","all")#","

","		","all")#","

","
","all")#","
","","all")#","
","","all")#","
","","all")#","
","","all")#

Coordonnées

#GetFicheInfo.Prenom# #GetFicheInfo.Nom#
 #GetFicheInfo.Societe#
 #replace (GetFicheInfo.Adresse ,chr(10),"
","all")#
 #Ville#,
#GetFicheInfo.Code_postal#
Tél. : #GetFicheInfo.Telephone# #GetFicheInfo.Telephone_desc#
 Tél. 2 : #replace (GetFicheInfo.TelephoneA,chr(10),"
","all")# #replace (GetFicheInfo.TelephoneA_desc,chr(10),"
","all")#
 Tél. 3 : #replace (GetFicheInfo.TelephoneB,chr(10),"
","all")# #replace (GetFicheInfo.TelephoneB_desc,chr(10),"
","all")#
 Tél. 4: #replace (GetFicheInfo.TelephoneC,chr(10),"
","all")# #replace (GetFicheInfo.TelephoneC_desc,chr(10),"
","all")#
 Télécopieur : #GetFicheInfo.Telecopieur# #GetFicheInfo.Telecopieur_desc#
 Courriel : #GetFicheInfo.Courriel#
 Site Web : #GetFicheInfo.web_anglais#

","		","all")#","

","		","all")#","

Galerie

#Photo_mini#http://#Replace("#GetFicheInfo.Web#","http://","","ALL")#http://#Replace("#Getbaseinfo.Web#","http://","","ALL")#/#GetFicheInfo.repertoire#/images/#Galerie.Photo_mini##Galerie.Photo#" WIDTH="50" HEIGHT="50' BORDER="1" ALIGN="center" vspace="5" hspace="5">
UPDATE fiches SET clic = Clic + 1 WHERE repertoire_no=#URL.Id#