
	Home > Ask the Domino Experts > ARCHIVE: LotusScript and Web Development Questions & Answers > Javascript: Open external database, retrieve a doc, and read a field?

Ask The Domino Expert: Questions & Answers

EMAIL THIS

Javascript: Open external database, retrieve a doc, and read a field?

EXPERT RESPONSE FROM: Dave Hatter

		Pose a Question

		Other Domino Categories

		Meet all Domino Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

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.

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	ARCHIVE: LotusScript and Web Development
	"Field or view column exceeds 32 Kb" errors from the @DBLookup formulas
	Agent to open an Excel file and pass the URL on for a Web query?
	WebQueryOpen/Save agent problem
	Using the function @DialogBox in a Web application
	Code for validation on a field
	Displaying info. in the order it appeared in the view
	Display from my Web page an an online link using Excel
	Creating a dynamic menu
	Using @Unique
	Code used for the HTML head content section

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

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.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

Lotus Notes Domino on Blackberry and mobile devices

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 1999 - 2009, TechTarget \| Read our Privacy Policy