Inspiring

Answered

Problème avec query group

2 replies
469 views
Translate

Bonjour,

Je voudrais faire un forum avec question, réponse, commentaire.

J'ai fait un select avec un query group mais les réponses ne s'affichent que si elle a au moins un commentaire !!

@
<CFQUERY name="Details2" datasource="#session.dbname#">
   SELECT

    Forum_Reponse.RID,
    Forum_Reponse.PID,
    Forum_Reponse.Rmessage,
    Forum_Reponse.RDateReponse,

    Forum_Comment.CID,
    Forum_Comment.RID,
    Forum_Comment.PID,
    Forum_Comment.Cmessage,
    Forum_Comment.CDateReponse

   FROM Forum_Reponse,Forum_Comment
   WHERE Forum_Reponse.PID=9
    And Forum_Reponse.RID=Forum_Comment.RID
   ORDER BY Forum_Reponse.RDateReponse,Forum_Comment.CDateReponse
</CFQUERY>

.

Merci pour votre aide.

Cordialement

This topic is closed to new replies. Start a new post to keep the conversation going.

EddieLotterCorrect answer

Inspiring

You need to use a left join.

Cheers

Eddie

EddieLotterCorrect answer

Inspiring

You need to use a left join.

Cheers

Eddie

Translate

Z

ZNBAuthor

Inspiring

Bonjour,

Merci pour votre aide. Cela marche bien !

Voici mon code :

@

SELECT

Forum_Reponse.RID,

Forum_Reponse.PID,

Forum_Reponse.Rmessage,

Forum_Reponse.RDateReponse,

Forum_Comment.CID,

Forum_Comment.RID,

Forum_Comment.PID,

Forum_Comment.Cmessage,

Forum_Comment.CDateReponse

FROM Forum_Reponse LEFT OUTER JOIN Forum_Comment

ON (Forum_Reponse.RID=Forum_Comment.RID)

WHERE Forum_Reponse.PID=#PID#

ORDER BY Forum_Reponse.RDateReponse,Forum_Comment.CDateReponse

</CFQUERY>

Avec un IF dans le 2ème groupe pour s'assurer s'il y a un enregistrement.

Translate

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.