Hello,
Here's a quick diff that seems to satisfy an item in TODO.txt:
...
[COLLABORATION]
o display the number of answers for each question. this will help
get people to
not only answer un answered questions, but will help prevent people
from
being disappointed when there are no answers to the question.
...
Feedback?
Regards,
~Eric
cvs server: Diffing .
Index: DisplayTopics.java
===================================================================
RCS file:
/products/cvs/jyve/jyve/src/java/org/apache/jyve/screens/DisplayTopics.java,v
retrieving revision 1.9
diff -r1.9 DisplayTopics.java
187a188
> sql.append ( " , sum(if(answer.deleted='N',1,0)) as answer_count");
189a191,192
> sql.append ( " left join answer on" );
> sql.append ( " question.question_id = answer.question_id" );
10a214,215
> sql.append ( " group by" );
> sql.append ( " question.question_id, question.question_value,
>question.topic_id" );
242a248
> int d_answer_count =
>qds.getRecord(j).getValue("answer_count").asInt();
255c261
< ) );
---
> ).addElement(" ("+d_answer_count+")") );
269c275
< }
\ No newline at end of file
---
> }
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
