88 |
$sql_travaux= "select travaux, substring(libelle,1,50) as lib from travaux where (nature ='".$this->nature."' or nature ='T')"; |
$sql_travaux= "select travaux, substring(libelle,1,50) as lib from travaux where (nature ='".$this->nature."' or nature ='T')"; |
89 |
$sql_evenement= "select evenement,(evenement||' '||libelle) |
$sql_evenement= "select evenement,(evenement||' '||libelle) |
90 |
from evenement where nature ='".$this->nature."' order by libelle"; |
from evenement where nature ='".$this->nature."' order by libelle"; |
91 |
$sql_instructeur= "select idutilisateur,nom from utilisateur where instructeur = 'Oui' order by nom"; |
$sql_instructeur= "select om_utilisateur,nom from om_utilisateur where instructeur = 'Oui' order by nom"; |
92 |
$sql_architecte= "select architecte,(nom||' '||prenom) from architecte order by nom"; |
$sql_architecte= "select architecte,(nom||' '||prenom) from architecte order by nom"; |
93 |
$sql_civilite= "select civilite,civilite from civilite order by civilite"; |
$sql_civilite= "select civilite,civilite from civilite order by civilite"; |
94 |
$sql_categorie_demandeur= "select categorie_demandeur,libelle as lib from categorie_demandeur order by categorie_demandeur"; |
$sql_categorie_demandeur= "select categorie_demandeur,libelle as lib from categorie_demandeur order by categorie_demandeur"; |