view_post method for a forum

[eluser]TheFuzzy0ne[/eluser]
I'd like to be able to find a posts position within it's parent topic by ID. I'd like to do this using the Active Record class, with no sub-selects id possible, and without adding an extra field to the database representing the position of that post.

So far, the best I could come up with, is simply to select the IDs of all of the posts in the topic, and iterate through those IDs to find the posts position. Does anyone else have any better ideas?

Many thanks.

The Fuzz.