Hi there,

You might want to check out the post I did on asp.net forums here:

http://www.asp.net/Forums/ShowPost.aspx?tabindex=1&PostID=831304

It has most of the SQL that you are looking for, although in DNN3, getting the address and phone info is a little more difficult (if not impossible) because it's stored as xml in one of the provider tables and not with each field in its own column like it was in DNN2.

Richard

I just downloaded your module and it has the closest I've found so far to what I want to do with my current site.  I posted this in the other place, but in case you don't see it I want to run it by you.  This is what I wrote...

I have a similar problem and can't seem to get this right (first time query attempt.) I am creating a real estate association site and I want to create a members display, members & associates display, and a estimators display, all coming from the user list defined into each category by roles. I want to show first and last name, office name (I traded out Instant Messager for Office Name in the form), phone number, and their designations (traded out fax for designations.) These are on 3 seperate pages. Any help would be greatly appreciated.

Designer,

I just posted a new HowTo article showing how you can get at some of this data along with a couple of user defined functions. Hopefully this will help you along your way.

Richard