SELECT Titre,Nom,Prenom,Societe,Sigle,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,Adresse2,Divers1,Divers2,Divers3,Divers4,Divers5,Divers6,Divers7,Divers8,Divers9,Divers10,Photo,Photo_mini,Photo_texte,Aussi_connu,Origine,Lieu,Annee,Information,Mission,Services,Realisations,Inventions,Exportation,Modification,Divers1_t,Url1,Divers2_t,Url2,Divers3_t,Url3,Divers4_t,Url4,Divers5_t,Url5,Divers6_t,Url6,Divers7_t,Url7,Divers8_t,Url8,Divers9_t,Url9,Divers10_t,Url10 FROM Fiches WHERE Repertoire_No=#attributes.Id# AND (Actif='1' or Actif='3') ORDER BY Nom; SELECT Id,Titre,Repertoire_No,Description,Photo,Duree,Format,Interpretes,Musiciens,Editeur,Realisation,Production,Suggestion,Web,Annee,Maison_disque,Etiquette,Distributeur,Pourcommander,Attachement, Attachement_texte, Attachement_Poid FROM Discographie WHERE Id=#attributes.Disc#

Discographie

#Titre#
 #Prenom# #Nom#

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

PhotoPhoto

Information

Support original

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

Interprètes

 #replace("#REReplace("#REReplace("#Interpretes#","([[: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")#

Musiciens

 #replace("#REReplace("#REReplace("#Musiciens#","([[: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")#

Éditeur

 #replace("#REReplace("#REReplace("#Editeur#","([[: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éalisation

 #replace("#REReplace("#REReplace("#Realisation#","([[: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")#

Production

 #replace("#REReplace("#REReplace("#Production#","([[: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")#

Visite Web

 #Suggestion##Web#
Référence au support discographique

Année de parution

 #Annee#

Maison de disques

#replace("#REReplace("#REReplace("#Maison_disque#","([[: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")#

Étiquette

#replace("#REReplace("#REReplace("#Etiquette#","([[: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")#

Distributeur

#replace("#REReplace("#REReplace("#Distributeur#","([[: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")#
Pour commander
#replace("#REReplace("#REReplace("#Pourcommander#","([[: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")#