SELECT Prenom,Nom,Repertoire,Titre,Photo,Photo_texte 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# #Titre#
 - #Prenom# #Nom# #Attachement# miserable%20songs #Titre# #Attachement_Texte# http://www.wimpyplayer.com/ecom/dlm/cart/cart.php%3Faction=add_item%26id=1%26c=abWm14WiYHd9w%26qty=1%26p=0.99%26k=abFe5UotyJq0Y 35.84 0.58 128 http://www.wimpyplayer.com/mp3s3/Killeen%20and%20Gieson%20-%20Alone.jpg

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