OK. I can see how to pull a list but not how to cycle through the elements within the SQLobject statement. .
I originally used a mapping table relationship to map person id and parent id so this SQL could then pull out all persons which were a parent of something SELECT p.id, p.title, count(r.id) c FROM person p, relationship r, WHERE p.id = r.parent_id GROUP BY r.parent_id ORDER BY p.insert_date DESC Any ideas how to write the equivalent of this? .M.
