Hi All,

 

I'm very new to XPages and stuck with an error I can't get past.  I have a custom control that has a repeat  container.  I have several computed fields displaying data from the repeat container and that works great.  Now I want to take one of those values and go fetch other values from another database to display.  So I added a computed field to the repeat container with the code below.  When the line executes to do the getDocumentByID I get the Error 500.

 

Any thoughts on this????

 

var currentDocument : NotesDocument = repeat1.getDocument();
var path = database.getFilePath().split(database.getFileName())[0]
var dbInfo = new Array(@DbName()[0],path + "otherDatabase.nsf");
aName= currentDocument.getItemValueString( "SomeFieldValue" );

aDocumentID = @DbLookup( dbInfo, "vwSomeView", aName, 5 );

if( aDocumentID )
{
    var locatorDocument : NotesDocument = database.getDocumentByID( aDocumentID[0] );  <<==  THIS LINE CAUSES THE ERROR
    if( locatorDocument )
        locatorDocument.getItemValueString( "PhoneNumber" );
}

else
        "N/A"