SELECT ShowType, ShowTypeColor FROM ShowType WHERE Repertoire_No=#attributes.Repertoire_No# ORDER BY ShowType SELECT S.ShowID, S.titre, S.extrait, S.description, S.credits, S.web, S.lieu, S.date_debut, S.date_fin, S.heure_debut, S.heure_fin, S.membre, S.selechoix, S.clientstypeid, ST.ShowType, ST.showtypeid, ST.ShowTypeColor, ST.extrait as STextrait FROM horaire S, ShowType ST WHERE S.ShowTypeID=ST.ShowTypeID#PreserveSingleQuotes(QryChoix)##PreserveSingleQuotes(QueryEvent)# AND (S.actif='1'or S.actif='3') AND S.langue='fr' AND S.Repertoire_No=#attributes.Repertoire_No# ORDER BY S.date_debut, S.heure_debut,S.Tri

Conférences et présentations

#ShowType#

#ShowType# : #STextrait#

#LSDateFormat(date_debut,'dddd, d mmm yy')#
#TimeFormat(heure_debut, "H")# h #TimeFormat(heure_debut, "mm")# à #TimeFormat(heure_fin, "H")# h #TimeFormat(heure_fin, "mm")#

#titre#

#lieu#

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