YES!!

HCL Notes/Domino 8.5 Forum (includes Notes Traveler)

Subject:

YES!!

It's finally working !
Here's my solution:

// SSJS CODE in onclick() event

//setting variables
var strc = String.fromCharCode(34);
var strQry1 = "SELECT * FROM MYDB.MYTABLE WHERE MYFIELD = '";
var strQry2 = "'";

var QRY = getComponent("inputText1").getValue();
var peopleView:NotesView = database.getView("MYQUERYVIEW");
peopleView.setSelectionQuery(strc+ strQry1 + QRY + strQry2 + strc);

getComponent("query").setValue(strc+ strQry1 + QRY + strQry2 + strc);

I do hope this can help someone !

Have you got any comments or idea to improve it ?

Perfomance are not bad:

seeking in a 100.000 records table i get the response in the web page within 2 - 3 secs...

Marco

Feedback response number WEBB7V5JA9 created by ~Holly Cisreburoden on 08/21/2009