Developer forum

peter@occ-innovation.dk wrote:

Hi there..

I've heard that it's possible to publish a list of Intranet/Extranet users with the Database publisher module.

I make a new view in the publisher module to access the Dynamicweb database..



When i select the database, and select any Table, i get an "Incorrect SQL statement".. I've then tried to write my own SQL statement, but i don't know what table in which the Users are listed..

Help? :)

/Peter

 

Hi Peter

There is no access to the AccessUser table from the Database publisher module.

Your query might be right, but the module will not let us acces the table, and there for we get that error message.

You have to write a custommodule if you want a list of extranet user, or you could look into the HR module.

In HR you can get lists af users.

/Kenneth

Oh, well i managed to gain access to the Extranet/Intranet Db afterall..

I just wrote my own SQL statement, instead of using the automatically generated statement.. (select * from [accessuser]t1)

It works nicely :)

/Peter