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  |  

DotNetNuke Marketplace
  Ads  
Engage Software - Training Partner for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Extend It! ( Pr...  How do you retrieve profile properties in sql query?
Previous Previous
 
Next Next
New Post 4/10/2008 9:59 AM
User is offline Karl Golling
31 posts
10th Ranked


How do you retrieve profile properties in sql query? 

I'd like to know how to retriev profile properties in an sql query.  Can anyone help out?

Thanks
 
New Post 4/10/2008 12:07 PM
User is offline Brian Dukes
477 posts
www.engagesoftware.com
8th Ranked


Re: How do you retrieve profile properties in sql query? 

The following query'll get basic user profile information.

SELECT u.UserId,
up.PropertyValue,
ppd.PropertyCategory,
ppd.PropertyName
FROM {databaseOwner}{objectQualifier}UserProfile up INNER JOIN
{databaseOwner}{objectQualifier}ProfilePropertyDefinition ppd ON
up.PropertyDefinitionID = ppd.PropertyDefinitionID INNER JOIN
{databaseOwner}{objectQualifier}vw_Users u ON
up.UserID = u.UserId

Hope it helps,

Brian Dukes
Engage Software
St. Louis, MO
314.966.4000

The leading provider of DotNetNuke support, training and custom module development.
 
New Post 4/14/2008 8:59 AM
User is offline Karl Golling
31 posts
10th Ranked


Re: How do you retrieve profile properties in sql query? 

Brian, Thank you, sorry for the late response.

It gives a partial solution to what I was looking for.  What I am looking for is a statement where I would be able to have the property names like

Select Username, Adr1, Adr2, Phone1, Phone2.  ... and other profilepropertyfields

Would that be possible?

Thank you again

 
 
New Post 4/14/2008 9:07 AM
User is offline Brian Dukes
477 posts
www.engagesoftware.com
8th Ranked


Re: How do you retrieve profile properties in sql query? 

That isn't the way that the information is structured in the database.  While you could write a query or a view to pivot the data in that way, I would probably suggest getting the raw data through a query like I presented, and then manipulating it once you get it back from the database.

Hope it helps,

Brian Dukes
Engage Software
St. Louis, MO
314.966.4000

The leading provider of DotNetNuke support, training and custom module development.
 
New Post 4/14/2008 12:40 PM
User is offline Karl Golling
31 posts
10th Ranked


Re: How do you retrieve profile properties in sql query? 

Thank you.  I can work with that. 

Karl
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  General DotNetN...  Extend It! ( Pr...  How do you retrieve profile properties in sql query?
 


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 Development and Strategy Firm
The Risdall Interactive Agency s websites, strategies, branding, & promotion in digital space.
www.Risdall.net/ 		Windsor Management Group
Fund Accounting Software for K12 Education.
Infinitevisions.com 		Convert Visitors to Customers
In order to bring value to your users, we must first understand them. VIVIDSITES will help you build a custom web application and interactive marketing tools that your users will thank you for. We marry high-end creative with head banging technology to entertain and convert visitors into paying customers. Call 314.514.0505 or visit us at http://www.vividsites.com to find out how.
- V I V I D S I T E S -

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