Hello,

I'm new in dotnetnuke and I need a member list.

All the information from the same member must be on the same line. One line per user.

It must be like

Username, name, firstname, email, adress, town , phone, cellphone ... each user can choose which information he want to display (visibility = 1)

The problem is that I have everything into a column.

I have written that :

SELECT PropertyValue

FROM UserProfile

WHERE

PropertyDefinitionID IN ('21','23','26','27','30','31','32','40')

and visibility=1

order by userid, propertydefinitionid

Can somebody help me please because I'm not good in sql

Thanks a lot

David

this doesn't seem to be related to the Forums module, therefore I move it over to a General Forum

Regarding your issue, I suggest to check out free Effority UserDirectory module (http://userdirectory.codeplex.com).

if you are on SQL Server 2005/2008, you may use "PIVOT" option (please see MSDN or SQL Server online help for details).