CODEWITHSUNDEEP
xpages
Timothy
Timothy

Reputation: 3

XPages dblookup issue

I have an item description from a third party lookup that contains an inch symbol. The DbLookup on Xpages does not seem to work with an inches symbol as the key. Example code:

var itemdesc = "BOLT F.T.(1/2" X 1-1/2")";

server = @Name("[CN]", @Subset(@DbName(), 1));

var db = new Array(server,databasename);

var itemcode = @DbLookup(db, view, itemdesc, 2,"[FAILSILENT]");

DbLookup returns undefined. Do you have any idea about this?

Upvotes: 0

Views: 116

Answers (1)

Howard
Howard

Reputation: 1503

Did you try var itemdesc = "BOLT F.T.(1/2\" X 1-1/2\")";

Upvotes: 1

Related Questions