Hi

I'm sure this has been asked a million times before, but I can't really find anything substantial out there.

I need to display all users row by row including whether they are authorized or not, firstname, lastname, display name, email addresses, and most of the profile fields (some of which I have customized).

Does anybody know where I might find a list of similar queries that I could take a look at, that does something similar if not exactly what I'm looking for?

Cheers!

Alex

---

---

---

The biggest problem with doing this is that the profile properties are stored in multiple rows and converting each row into a column for that user would be very tricky. Perhaps someone with more SQL experience can provide some insight?

---

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer

I put together a few mini-modules a while back to use as a training resource, they both do custom queries against the profile properties, perhaps they would be of help to you . They're at http://www.cathal.co.uk/Default.aspx?tabid=86 (also don't forget that the non-profile properties are in the vw_Users view)

Cathal

---

Buy the new Professional DNN7: Open Source .NET CMS Platform book Amazon US