@DbLookup not working in Web -?

Hi everyone!

I wanted to get a username from Address book while in working in a web (IE). Anonymous access level is Reader.

LN documentation says, that DbColumn will not work this way, but DbLookup should. But it doesn’t.

Any ideas?

Thanks everyone,

Dmitry.

Subject: @DbLookup not working in Web - ?

As far as I know @dblookup works in web if and only if the web is user logged in.

As you are saying the anonymous access is reader so it should not ask for login and that is the problem.

Regards

Nidhish

Subject: RE: @DbLookup not working in Web - ?

No – @DbLookup works fine on the web if the formula is written correctly and the user (anonymous or logged in) has access to the database, view, and at least one document with the key specified in the lookup.

Subject: RE: @DbLookup not working in Web - ?

If I had $5 for every posting in these forums with that subject line…

@DbLookup works just fine in Domino web applications. Where, precisely, did you find any documentation that seems to you to suggest otherwise?

Subject: RE: @DbLookup not working in Web - ?

I request to go through previous posting related to @dblookup. Here is the link.

http://www-10.lotus.com/ldd/nd6forum.nsf/55c38d716d632d9b8525689b005ba1c0/80d48bb2e0859aa485256e590012b79b?OpenDocument

Subject: RE: @DbLookup not working in Web - ?

Bill’s response to your question in that thread was not sufficiently clear.

It is not true that @DbLookup will only work in a web application if the user is logged in.

What makes a difference is that the user must have access to the view and document they are looking up.

In your case, anonymous users did not have access to your view. You could have fixed the problem by changing the database ACL so that users who are not logged in can read the view. Forcing the user to login is not the only way – and in fact, forcing the user to login doesn’t even solve the problem in all cases – the ID they use still has to have access to the database!