Javascript: Open external database, retrieve a doc, and read a field? |
 |
EXPERT RESPONSE FROM: Dave Hatter
|
|
|
| > |
QUESTION POSED ON: 19 April 2002
Is it possible through Javascript to open an external database, retrieve a sbpecfic document, and finally read a field off of that document? I need to do this on a form after a part number field is entered and then go out and get this external data and fill in another field on the form.
|
|
| > |
JavaScript is primarily used as a client-side scripting language. So, there is no way to do this directly, but there are other ways to accomplish this. If the user is entering the number in a text field (<INPUT type-="text") , you could have the user click a button or a link that that would submit the form to the server and then either run a server side script (agent in LotusScript or Java) from the WebQuerySave event of the form that could retrieve the value and write it to profile doc, or add it to a querystring parameter. You'd then redirect them back to the form with additional information, which would be added via a WebQueryOpen agent.
There are other ways that might work, but an approach similar to the one outlined above is probably the most flexible.
|
|
|
|
|
|
|
|
Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
|
|
|
|
|
|
|
|
|
|
|
|
