hi there,
i am looking for some help on a @DBLookup on an XPage, which after a bit of research, one of the keywords you can use is [FAILSILENT]. Does this work, or am i just coding it wrong??
FLSCall.setValue(“SN”, @DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 2, [FAILSILENT]));
FLSCall.setValue(“DeptList”, @DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 3, [FAILSILENT]));
FLSCall.setValue(“PhoneList”,@DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 5, [FAILSILENT]) + @DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 4, [FAILSILENT]));
FLSCall.setValue(“WebEmail”, @DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 6, [FAILSILENT]));
Thanks for any help.
Jamie
P.S. I have also tried coding around the error when it cannot find an entry, but I dont know what it returns, so i cant error check against it!
UserCode = @DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 2);
Department = @DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 3);
Phone = @DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 5) + @DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 4);
Email = @DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 6);
@If(UserCode = @Error,FLSCall.setValue(“SN”,“”), FLSCall.setValue(“SN”,Usercode));
@If(Department != “”,FLSCall.setValue(“DeptList”,Department), FLSCall.setValue(“DeptList”,“”));
@If(Phone != “”,FLSCall.setValue(“PhoneList”,Phone), FLSCall.setValue(“PhoneList”,“”));
@If(Email != “”,FLSCall.setValue(“WebEmail”,Email), FLSCall.setValue(“WebEmail”,“”));
Can someone tell me what value it returns when it cannot find an entry??
Thanks!
P.P.S. I have also tried the following - no effect! :
UserCode = @DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 2);
Department = @DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 3);
Phone = @DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 5) + @DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 4);
Email = @DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 6);
@If(UserCode == null,FLSCall.setValue(“SN”,“”), FLSCall.setValue(“SN”,Usercode));
@If(Department == null,FLSCall.setValue(“DeptList”,“”), FLSCall.setValue(“DeptList”,Department));
@If(Phone == null,FLSCall.setValue(“PhoneList”,“”), FLSCall.setValue(“PhoneList”,Phone));
@If(Email == null,FLSCall.setValue(“WebEmail”,“”), FLSCall.setValue(“WebEmail”,Email));