Hello All,
I just commited a patch for DisplayTopics.java.
The whole problem is getting the number of answers for
each question.
The solution in postgres is to use union selects
The solution in mysql is to use left outer joins
The default solution would be then to select count(*) from
answers where answer.question_id = x (looping over all relevant questions)
The patch tries the first one, then the second one, then
finally it just returns 0 for each. I did not implement
the last one. Hopefully, the first two will cover most.
The union select statement is SQL92. The left outer join stuff
has sql specific syntax for mysql.
If someone REALLY REALLY REALLY wants the third one to work as well,
I can do it.
The good news is that even if your dbase doesn't support either
of sql syntax, jyve won't be throwing exceptions at you.
One note: I haven't tested this under mysql! (I just copied
the old code).
mike
--
--------------------------------------------------------------
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Archives and Other: <http://java.apache.org/main/mail.html>
Problems?: [EMAIL PROTECTED]
