SELECT Prenom,Nom,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,width,height,Photo_texte,repertoire 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;

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">

 


#Photo#http://#Replace("#Individu.Web#","http://","","ALL")#http://#Replace("#getbaseinfo.Web#","http://","","ALL")#/#individu.repertoire#/images/#Photo#">#Photo#http://#Replace("#Individu.Web#","http://","","ALL")#/images/#Photo#" menu=false quality=high WIDTH="#width#" HEIGHT="#height#" ALIGN="MIDDLE" TYPE="application/x-shockwave-flash" PLUGINSPAGE="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash">Photo - #Photo_texte# � Tous droits réservéshttp://#Replace("#getbaseinfo.Web#","http://","","ALL")#/#individu.repertoire#/images/#Photo#" ALT="Photo - #Photo_texte# © Tous droits réservés" BORDER=0 ALIGN="MIDDLE">
#replace(Photo_texte,chr(10),"
","all")#

#Individu.Prenom# #Individu.Nom#

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")#

Écrivez

#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#