How in hell will i do this in script!

HCL Domino Domino Forum
1

I think i should use Evaluate in some way…but how?

server := “”;

database := “”;

view := “(CheckActiveUser)”;

key := “Active”;

columnNumber := 2;

Choise := @DbLookup( “Notes” : “NoCache” ; server : database ; view ; key ; columnNumber);

@If(@IsError(Choise);“”;@Trim(@Unique(Choise)));

Kind regards

Fredrik

2

Subject: How in hell will i do this in script!

Dim temp as Varianttemp = Evaluate({@Do(

server := “”;

database := “”;

view := “(CheckActiveUser)”;

key := “Active”;

columnNumber := 2;

@DbLookup( “Notes” : “NoCache” ; server : database ; view ; key ; columnNumber);

@If(@IsError(Choise);“”;@Trim(@Unique(Choise))))})

Choise = temp(0)

3

Subject: Oops … accidently deleted a variable

This is better

Dim temp as Variant

temp = Evaluate({@Do(

server := “”; database := “”; view := “(CheckActiveUser)”; key := “Active”; columnNumber := 2;

Choise := @DbLookup( “Notes” : “NoCache” ; server : database ; view ; key ; columnNumber); @If(@IsError(Choise);“”;@Trim(@Unique(Choise))))}) Choise = temp(0)

4

Subject: RE: Oops … accidently deleted a variable

Should use temp not temp(0) as I’m sure he wants all the choices, not just the first one.

5

Subject: RE: Oops … accidently deleted a variable

Thanx, you are my hero…I REALLY hate Evaluate, it’s always get me trouble.