Given the following sql data, how do I select this hierarchically to produce a list with the parents/children in the proper order (children ordered by rightsorder)?

Looks like you are using a reflexive table todefine the hierarchy, right? You would probabaly be better off to separate the data from the structure of the hierarchy.

You can download the white paper and code samples from the tools and utilities page of my web site from my conference presentation entitled "Modeling Hierarchies". The sample are all VFP, but it gives you the concepts.