Can anyone tell me how to create an SQL query that will get me complete user information in DNN 3? 

i.e.

John Doe, address, telephone, city, state, zip, country, etc. etc.

For something that "list"esque? That would be hard, because DNN stores most of the user profile stuff as XML.

I think people can help you get to the XML, but the parsing would need to be done in some type of code - unless you're running in Oracle 9i or 10g, which I think have XML parsing capability within the SQL interface.

The info is in the NTEXT field, PropertyValuesString, of the aspnet_Profile table.  I am not sure how to extract it intelligently, at the moment.  I can put my mind to it in the morning and have something for you, if you still need it.  Gotta hit the road, right now.

Let me know.

Ling

Hi Gang,

Just got back in town and this is still an issue for me.  The real problem is that I really need to be able to query results based upon zip codes, or regions or states, etc.  Being able to parse the information is crucial in this regard.  Please let me know what you've found.

Thanks again.