Hi guys!I have a domino web server 6.5.1 running on a win2k server , and i’ve a web application with a form that needs to pickup two fields from another view using this @dblookup :
KeyDoc:=@DbLookup(“”:“”;@Subset(@DbName;1):@Subset(@DbName;-1) ;“(Search by key)”;tNumber;2);
@If(@IsError(KeyDoc);“”;KeyDoc)
this server is currently working on a internal lan and it have a external ip address(NAT) for access it from the internet.
If i launch this form from the “internal” lan works and yes the viev have the 1st column sorted.
If i try to access the page from the internet i get a “Entry not found in index” when it try to do that @dblookup.
It seems that the server don’t know from where it have do do that search, and yes i did searches here and on the R5 db but i haven’t found anything.
I think i have to remove the dblookup’s and move to some lotusscript code, but there is any good explanation for this?
Can someone help me or explain why this happens??
Thanks a lot!
Ciao
Alberto Ernestini
ISA SPA
Subject: @DbLookup and web works but not if i use NAT please HELP!
To look up in the current database, use “” instead of @Subset(@DbName;1):@Subset(@DbName;-1). That’s probably not what’s causing your problem here.
@DbLookup should work, and if it doesn’t, there are probably reasons that would prevent LotusScript from working in that situation also.
When you talk about how you access the form, please specify which client you use to access it with and whether you have authenticated. The Domino server doesn’t distinguish based on where the request comes from. But @functions can work differently depending where they are executed – on the server or on your Notes client. It might also make a difference whether you are authenticated on the site or considered an “Anonymous” user.
Here’s a tip: Very often, when you think the problem is with a particular function, the difficulty is actually with the inputs you are giving that function. Use @IfError to intercept the error returned by @DbLookup and instead return a string containing your key value, tNumber – it may be incorrect.
Subject: RE: @DbLookup and web works but not if i use NAT please HELP!
Thanks for your answer!I try to explain better the scenario :
The users should do a login for access this db ( and this form).
When i open this form from an authenticated IE 6.0 client, and if i check the value of this field (using @text(@dblookup…) this is what i get :
Form opened from ie/internal lan ( 10.0.0.20 by example) i always get the right field value
Form opened from ie/INTERNET (80.x.x.x) i get Entry not found in index
This is strange because the @dblookup should works from both sides…
What’s wrong then?
Thanks!
ciao
Alberto.