FailSilent Keyword on Xpage DbLookup

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));

Subject: The proper syntax is…

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("DeptList","");

FLSCall.setValue("PhoneList","");

FLSCall.setValue("WebEmail","");

}else{

FLSCall.setValue("SN",UserCode);

FLSCall.setValue("DeptList",Department);

FLSCall.setValue("PhoneList",Phone);

FLSCall.setValue("WebEmail",Email);	

}

Subject: you can use FAILSILENT

you should put it within quotes :@DbLookup(@DbName(), “(UserLU)”, FLSCall.getItemValueString(“NameList”), 2, “[FAILSILENT]”);