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  
Aspose - The .NET & Java component publisher
 


  Sponsors  

Meet Our Sponsors

DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
Jango Studios - Skins, Modules and Hosting for DotNetNuke
eUKhost.com is commited to offer exceptional UK Windows Web Hosting solutions with quality 24x7 technical support.Our plans support ASP.Net, ASP, ASP.NET Ajax extensions, XML, MSSQL, MySQL, PHP,DNN, multiple domains and Shared SSL as standard.
SmarterTools
Verndale
 


DotNetNuke Forums
 
  Forum  General DotNetN...  Extend It! (Pro...  Cant find profile details?
Previous Previous
 
Next Next
New Post 9/5/2008 9:16 AM
Resolved
User is offline RevoTech
6 posts
10th Ranked


Cant find profile details? 

Hi everybody.

We cant find the profile details of a user..? To be more specific...we coding an sms module for our project so we wanted to grab the cell number from a user's details. But we cant seem to find it anywhere in the tables (User, Profile, UserProfile etc)

Does anyone know where we can get it from?

I tried browsing the forums a bit..found the same question posted in June 2006 and no one replied to the poster..so Im hoping for more luck. ;)

thanks

Daryn
 
New Post 9/5/2008 11:23 AM
Accepted Answer 
User is offline Fooberichu
475 posts
www.seeleyware.com
8th Ranked


Re: Cant find profile details? 

If it isn't stored using the UserPersonalization code (in other words, saved as an actual profile property), then the values ARE stored in UserProfile table.  You need to find out what the PropertyDefinitionID of the property is and that is defined in the ProfilePropertyDefinition table.

Sample SQL script:

select * from UserProfile where PropertyDefinitionID = (select propertydefinitionid from ProfilePropertyDefinition where PropertyName = 'Cell' and PortalID = 0)

-- Fooberichu
http://www.seeleyware.com
 
New Post 9/7/2008 2:55 AM
User is offline RevoTech
6 posts
10th Ranked


Re: Cant find profile details? 

thanks bud. that makes sense.

We found it now. There was a cell number value in the UserProfile table...in the PropertyValue column along with many other different types of attributes. I guess we struggled to find it first because we naturally assumed the tables would be in third normal form. tsk tsk (we still fairly new to DNN)

 

thanks again.

 
 
New Post 9/7/2008 3:38 AM
User is offline Sebastian Leupold
15216 posts
www.deutschnetnuke.de
1st Ranked












Re: Cant find profile details? 

customizable tables are often stored in a serialized format for greatest flexibility, otherwise you cannot provide separate table layouts per portal in a single table. Same method is used by UserDefinedTable :-)

Sebastian Leupold

DeutschNetNuke dnnWerk - The DotNetNuke Experts German DotNetNuke User-Group

DotNetNuke Project UserDefinedTable
DotNetNuke Project Release Tracker
 
 Page 1 of 1
Previous Previous
 
Next Next
  Forum  General DotNetN...  Extend It! (Pro...  Cant find profile details?
 


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.
 


AFUEGO!
Looking for Free DNN Hosting?
www.AFUEGO.com 		Code 5 Systems, LLC.
The DNN Missing Link: A Form Module. Form Master 1.6 is an intuitive Form Creation Module at a great price. Quality Custom Module development, and DNN consulting services.
www.code5systems.com 		SSL Enabled and Amazingly FAST...
SSL enable your DNN web site with SSLRedirect, compress your DNN web site HTTP data flow by up to 75%-90% with HttpCompressionAgent, and monitor your DNN web site's performance with WebKeepAlive...
www.sanibellogic.com

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