Hi, in my application, i try to display the number of
comments for each subject in a list. The problem is that the total
number of records are returned by the loop query for each subject,
even if the there is no comments for the subject related. Anybody
can help me? Here is the code :
<cfquery name="Qsujets" datasource="Modules_Web">
SELECT *
FROM dbo.Sujet
ORDER BY SUJ_ID
DESC
</cfquery>
<cfquery name="Qcommentaire" datasource="Modules_Web">
SELECT *
FROM dbo.Commentaire
</cfquery>
<html>
<head>
<title>Liste des sujets</title>
<link href="/sites/1676/commentaires/CSS/styles.css"
rel="stylesheet" type="text/css" />
</head>
<body>
<h1>Liste des articles </h1>
<br />
<cfoutput query="Qsujets">
<ul><li>
<span
class="sujets">#Qsujets.SUJ_Nom#</span><br />
<span
class="auteur">#Qsujets.SUJ_Auteur#</span><br />
<span
class="description">#Qsujets.SUJ_Description#</span><br
/>
<div id="bloc_sujet">
<table>
<tr>
<td><img
src="/sites/1676/commentaires/images/oeil.gif" alt="Lire les
réactions " width="20" height="20" /></td>
<td><a
href="/index.cfm/2,0,1676,9914,2832,0,html?COM_ID=#Qsujets.SUJ_ID#">Lire
les réactions à cet article </a>
(#Qcommentaire.RecordCount#)</td>
<br />
</tr>
<tr>
<td><img
src="/sites/1676/commentaires/images/comment.gif" alt="Réagir"
width="20" height="19" /></td>
<td><a
href="liste_com.cfm?COM_ID=#Qsujets.SUJ_ID#"></a><a
href="/index.cfm/2,0,1676,9914,2831,0,html?SUJ_ID=#Qsujets.SUJ_ID#">Réagir
à cet article</a></td>
</tr>
</table>
______________________________________</div>
</li></ul>
</cfoutput>
</body>
</html>
1
Reply
AdChoices