Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

Affordable ASP.NET Hosting Service
  Ads  
OnyakTech
 


  Sponsors  

Meet Our Sponsors

Portal Webhosting - Hosting For Developers
Red-Gate Software
MaximumASP
SourceGear - Tools for Developers
.: CounterSoft :.
telerik
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Reports Module ...  Listing Users (again?)
Previous Previous
 
Next Next
New Post 1/26/2007 8:30 AM
User is offline Alex Shirley
2189 posts
5th Ranked




Listing Users (again?) 
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

Well might as well promo one of my DNN sites as I'm here: http://www.snasty.co.uk
 
New Post 2/11/2007 7:36 AM
User is offline DCC
2 posts
10th Ranked


Re: Listing Users (again?) 

Hi,  I'd sure like to know how to do this as well.  I've been searching the forums, but can't find anything.  Please let me know if you find anything.

Thanks! Denise

 
New Post 2/11/2007 8:44 AM
User is offline Andrew Nurse
366 posts
8th Ranked






Re: Listing Users (again?) 
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

 
New Post 2/11/2007 9:54 AM
User is offline Alex Shirley
2189 posts
5th Ranked




Re: Listing Users (again?) 

Exactly Andrew... I got stumped in the end.

Anybody out there up to the challenge?

Cheers

Alex


Well might as well promo one of my DNN sites as I'm here: http://www.snasty.co.uk
 
New Post 2/11/2007 11:40 AM
User is offline cathal connolly
2756 posts
www.cathal.co.uk
5th Ranked










Re: Listing Users (again?) 

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

 
Previous Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Reports Module ...  Listing Users (again?)
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, please observe the following posting guidelines:

1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Web Valley
Website design, Database development
www.webvalley.com
UK DotNetNuke CMS installation, hosting & support
UK based installation, branding, customising, integration, hosting, training, support and maintenance services for DotNetNuke
www.deburca.co.uk
Need Help with your DotNetNuke website?
Jango Studios offers exclusive DotNetNuke Skin Design, Module Development, Web Marketing and Web Hosting.
www.jangostudios.net

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP