Why is my Frame formula not working correctly

HCL Domino Domino Forum
1

Well I have a frame and I am trying to put some code to display a different banner depending on a date list in one of 6 keyword documents. For some reason the code displayed the correct banner yesterday but today it wont change like it should. Here is my code…

red := @DbLookup(“” : “NOCache”; “” : “”; “KwdLKUP”; “Red” ; ListValues);

green := @DbLookup(“” : “NOCache”; “” : “”; “KwdLKUP”; “Green” ; ListValues);

yellow := @DbLookup(“” : “NOCache”; “” : “”; “KwdLKUP”; “Yellow” ; ListValues);

white := @DbLookup(“” : “NOCache”; “” : “”; “KwdLKUP”; “White” ; ListValues);

violet := @DbLookup(“” : “NOCache”; “” : “”; “KwdLKUP”; “Violet” ; ListValues);

rose := @DbLookup(“” : “NOCache”; “” : “”; “KwdLKUP”; “Rose” ; ListValues);

redURL := “internal URL.swf”;

greenURL := “internal URL.swf”;

yellowURL := “internal URL.swf”;

whiteURL := “internal URL.swf”;

violetURL := “internal URL.swf”;

roseURL := “internal URL.swf”;

@Text(@If(

@Contains(@Text(@Date(@Today)); red); redURL;

@Contains(@Text(@Date(@Today)); green); greenURL;

@Contains(@Text(@Date(@Today)); yellow); yellowURL;

@Contains(@Text(@Date(@Today)); white); whiteURL;

@Contains(@Text(@Date(@Today)); rose); roseURL;

@Contains(@Text(@Date(@Today)); violet); violetURL;

greenURL))

Probably not the most efficent code but it should work…am I missing something here? The lookups are working…each keyword document has about 30 dates in it…todays date should show the violet.swf banner in the Top frame but its still showing yesterdays banner which was red.swf…even when I removed the date when testing yesterday it still displayed the red banner even if the date was no longer included in that keyword document…HELP!

2

Subject: Why is my Frame formula not working correctly…

Are you sure your lookups are working? In your DBLookup ListValues should be in quotes “ListValues”?

3

Subject: RE: Why is my Frame formula not working correctly…

geez…I feel like an idiot :confused: thanks alot for pointing out the obvious. I guess when ya stare at it for so long you can overlook the smallest of things…thanks! Code works great now :slight_smile: