How to Achieve this in Web?

HCL Domino Domino Forum
1

Hai, i have this requirement and i am looking for a best possible way to achieve it.

→ I have a SQL Query which fetches 400 records(Items).

Each Item record has a price and discount value.

→ I have to display the entire 400 records on the web and let the user modify the price and discount.

Once they are done modifying , the update has to be sent back to Db2.

→ My question here is whats the best possible way to achieve this in web ?

→ I dont want to create 400 documents each time this has to be done.

→ I want this application to be fast. So somehow i have to do the field edits in the front end.

→ I cannot create static fields on the form. The no of records has to be dynamic.

Some one good in web development please advice me. Is there any new feature in Notes 8.5 which helps in achieving this kind of requirement. Thanks in advance.

2

Subject: XPages

Use jdbc (I like jtds – net.sourceforge.jtds.jdbc.Driver)Populate a 3 column data table with Item (not editable), price, discount.

You can page it using the pager control.

You can use a button to gather up the data on a page and sent it back to DB2 via RDBC, or you could put a function in the onchange event of each editable field (particularly if edits are sporadic). Use onkeypress, too, but only if you validate the key with client JS like:

if (thisEvent.keyCode != ‘13’ ) {

return false;

}

People tend to expect hitting the return key to execute.

Not using XPages would be much more involved.