On 11/30/11 7:09 AM, Sibylle Koczian wrote:
> Should I put the complete script to dabo.codepad.org? It's not very long.
Yes. You could also turn on the dbActivityLog and see the SQL run to get the
categories, which should look something like:
"""
select reccats.id as id,
reccats.name as name
from reccat
inner join reccats
on reccats.id = reccat.catid
where reccat.recid = ?
"""
The sql to get the recipes for a given category would be something like:
"""
select recipes.id as id,
recipes.title as title
from reccat
inner join recipes
on recipes.id = reccat.recid
where reccat.catid = ?
"""
If that where clause isn't present, and/or the join isn't 'inner', that could
be the
issue. I haven't looked at the new MM stuff yet but perhaps it is by design
that the
where clause isn't there. If so, you'd probably need a 'group by 1' to keep the
recipes/categories from showing up multiple times.
Paul
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/[email protected]
