SELECT q.tri, q.type, q.questionid, q.attachid, q.titre, q.description, q.extrait, q.theme, q.suggestion, q.web, q.photo_mini, q.photo_texte, q.niveau1, q.novote, q.iden, a.answerid, a.niveau2, a.answer, a.votes,a.retrait, a.saut, a.idfr, a.iden as englishid FROM question Q INNER JOIN answer A ON Q.questionid=A.questionID WHERE Q.repertoire_no=#attributes.repertoire_no# AND Q.nature='enquete'#PreserveSingleQuotes(qrysuivant)##PreserveSingleQuotes(QryQuestion1)##PreserveSingleQuotes(AttachidQuery)##PreserveSingleQuotes(QryAnswer1)##PreserveSingleQuotes(ActifQuery)# ORDER BY q.questionid,A.tri SELECT q.tri, q.type, q.questionid, q.attachid, q.titre, q.description, q.extrait, q.theme, q.suggestion, q.web, q.photo_mini, q.photo_texte, q.niveau1, q.novote, q.iden, a.answerid, a.niveau2, a.answer, a.votes,a.retrait, a.saut, a.idfr, a.iden as englishid FROM question Q INNER JOIN answer A ON Q.questionid=A.questionID WHERE Q.repertoire_no=#attributes.repertoire_no# AND Q.nature='enquete'#PreserveSingleQuotes(Qrysuivant2)##PreserveSingleQuotes(QryQuestion2)##PreserveSingleQuotes(AttachidQuery)##PreserveSingleQuotes(QryAnswer2)##PreserveSingleQuotes(ActifQuery)# ORDER BY q.questionid,A.tri SELECT * FROM Resultats WHERE reponse='1' AND actif='1'#PreserveSingleQuotes(QryQuestion)##PreserveSingleQuotes(QryAnswer)# ORDER BY answerid,nombre,description desc;

#GetBaseInfo.Titre#

#NumReponse# RÉPONDANTS correspondent à :

WHERE Q.repertoire_no=#attributes.repertoire_no# AND Q.nature='enquete'#PreserveSingleQuotes(qrysuivant)##PreserveSingleQuotes(QryQuestion1)##PreserveSingleQuotes(AttachidQuery)##PreserveSingleQuotes(QryAnswer1)##PreserveSingleQuotes(ActifQuery)#
WHERE Q.repertoire_no=#attributes.repertoire_no# AND Q.nature='enquete'#PreserveSingleQuotes(Qrysuivant2)##PreserveSingleQuotes(QryQuestion2)##PreserveSingleQuotes(AttachidQuery)##PreserveSingleQuotes(QryAnswer2)##PreserveSingleQuotes(ActifQuery)#
WHERE reponse='1' AND actif='1'#PreserveSingleQuotes(QryQuestion)##PreserveSingleQuotes(QryAnswer)#

à la question numéro #tri# : #description#
dont la réponse est :

#Answer#