DBLookup caching information

In the INotes db I am doing a simple db lookup.@DbLookup( “”:ReCache ; “” ; “(Signature)” ; @Name([CN]; @UserName) ; “AutoAdd” )

The only time the information returned is updated is if I go into designer and save any element. The element I save doesn’t have to have anything to do with the dbLookup. Even if I have the server and file name explicitly listed the data returned is still cached. The view is set to update automatically. I have changed fields that I am looking up and get the same result.

Thanks for any help

Subject: Try: @DbLookup( “” : “ReCache”; … Note the ""s

Subject: RE: Try: @DbLookup( “” : “ReCache”; … Note the ""s

I think have your post was cut off. Are you saying to use … instead of “” where the notes server and file name are supposed to be listed.?

Subject: RE: Try: @DbLookup( “” : “ReCache”; … Note the ""s

No, he means use “ReCache” instead of ReCache. The first is a string in quotes, while the second is a variable which resolves to “”, probably, since you have never defined it as anything.

Subject: RE: Try: @DbLookup( “” : “ReCache”; … Note the ""s

I’m tempted to say something silly here :wink:

But instead…

try adding quotes around “ReCache”

Subject: RE: Try: @DbLookup( “” : “ReCache”; … Note the ""s

Thanks! This is certainly a case where it helps to have someone else look at your code.