Forum OpenACS Q&A: Response to Bug in neighbor-to-neighbor

Collapse
Posted by Roberto Mello on

Yes, this is 3.2. After your nice SQL explanation, I changed the query to:

select about,approved_p
from neighbor_to_neighbor
where subcategory_id = 1
and approved_p='t'
and about is not null
group by about,approved_p
order by upper(about)

and it yielded the correct results (e.g. only approved posts are shown).

I'll modify the other similar n_to_n queries (like in new-stuff.tcl) and send them to the module maintainer at aD. Maybe he's changing it to the new model that you described (where did you find that out anyway?).

Would we want to go with this version or wait for the official aD release ?