I'm trying to get a basic xpage to show totals for completed cases from a number of product databases.  This is the JavaScript value of a computed field on a custom control:

var db = new Array(@DbName()[0], 'otherdatabase.nsf')

var today = new Date();

var yr = today.getFullYear().toString()

var mth = (today.getMonth()+1).toString();

if(mth.length == 1){

mth = "0" + mth

}

var dy = today.getDate().toString();

if(dy.length == 1){

dy = "0" + dy

}

var KEY = yr+mth+dy;

completed = @DbLookup(db, VIEW, KEY, 2);

if (completed != null){

@Elements(@Trim(@Explode(completed)));

}

else

{

return 0;

}

This looks up a view that has the first categorised column that does match the data value.  The idea is that I should be able to look up the completed cases for any given date eventually.

However it is only ever returning 0.

By comparison the computed text on a form as follows works perfectly:

TEXT := "Product 1";

DBFILE := "otherdatabase.nsf";

SERVER := @Subset( @DbName; 1 );

DIR := @Left(@Subset( @DbName;-1 ); "\\" );

DIR := @If( @Contains( @LowerCase(DIR); "dev" );

"ncidev"; @Contains( @LowerCase(DIR); "test" );

"ncidev"; "instruction" );

DBASE := DIR + "\\" + DBFILE;

VIEW := "lookupcompletedbydate";

yr := @Text(@Year(@Today));

mth := @Text(@Month(@Today));

theMonth := @If(@Length(mth) = 1; "0" + mth; mth);

dy := @Text(@Day(@Today));

theDay := @If(@Length(dy) = 1; "0" + dy; dy);

KEY := yr+theMonth+theDay;

VAL := @DbLookup( "":""; SERVER: DBASE; VIEW;KEY; 2 );

VAL := @Elements( VAL );

TEXT + ": " + @Text(VAL)

What am I doing wrong?