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 Photo_mini,Id,Repertoire_No FROM Galerie WHERE Repertoire_No=#URL.Id# AND (Actif='1' OR Actif='3') ORDER BY tri,Photo1 desc;

 


#individu.Prenom# #individu.Nom#

#Photo#http://#Replace("#individu.Web#","http://","","ALL")#/images/#individu.Photo#" BORDER="1" ALIGN="right">

Information

#replace("#REReplace("#REReplace("#individu.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")#",chr(10),"
","all")#

Démarche artistique

#replace("#REReplace("#REReplace("#individu.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")#",chr(10),"
","all")#

Expositions

#replace("#REReplace("#REReplace("#individu.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")#


Emplois

#replace("#REReplace("#REReplace("#individu.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")#",chr(10),"
","all")#

Formation

#replace("#REReplace("#REReplace("#individu.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")#",chr(10),"
","all")#

Projets

#replace("#REReplace("#REReplace("#individu.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")#",chr(10),"
","all")#

Expériences

#replace("#REReplace("#REReplace("#individu.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")#",chr(10),"
","all")#

Services

#replace("#REReplace("#REReplace("#individu.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")#

Coordonnées

#individu.Prenom# #individu.Nom#
#individu.Societe#
#replace (individu.Adresse ,chr(10),"
","all")#
#Ville#,
#individu.Code_postal#

Téléphone : #individu.Telephone# #individu.Telephone_desc#
Téléphone 2 : #replace (individu.TelephoneA,chr(10),"
","all")# #replace (individu.TelephoneA_desc,chr(10),"
","all")#

Téléphone 3 : #replace (individu.TelephoneB,chr(10),"
","all")# #replace (individu.TelephoneB_desc,chr(10),"
","all")#

Téléphone 4: #replace (individu.TelephoneC,chr(10),"
","all")# #replace (individu.TelephoneC_desc,chr(10),"
","all")#

Télécopieur : #individu.Telecopieur# #individu.Telecopieur_desc#
Courriel : #individu.Courriel#
Autre site Web : #individu.Web_anglais#

Galerie

#Photo_mini#http://#Replace("#individu.Web#","http://","","ALL")#http://#Replace("#getbaseinfo.Web#","http://","","ALL")#/#individu.repertoire#/images/#Galerie.Photo_mini##Replace("#Galerie.Photo_mini#",".gif","_m.gif","ALL")#" WIDTH=50 HEIGHT=50 BORDER=1 ALIGN=center vspace=5 hspace=5 alt="Visionnez" title="Visionnez">
«   #pageidx# #pageidx#   »

UPDATE fiches SET clic = Clic + 1 WHERE repertoire_no=#URL.Id#