JFS
|
| Posted: 05/27/2003, 12:48 PM |
|
Is it possible to have a partnumber entered by a user, and have a description field updated when the user tabs out of the partnumber field. The description has to be pulled from the database due to the number of inventory items. Any help greatly appreciated.
|
|
|
 |
DeWebDude
|
| Posted: 06/03/2003, 7:24 PM |
|
I would beleive the only way to do this is have java call the db with the part number and return the result...
Sorry I couldn't give you more details, but java would be one of the few ways to get that dynamically
|
|
|
|
rclayh
|
| Posted: 06/04/2003, 6:46 PM |
|
You could do it, but it would require a round trip to the server. You would want to write a small javascript to submit the form on the "lostFocus" event of the textbox. Note that doing it that way will mean the page will submit even if they tab out of the field and don't put in any value. You may be able to tie to the enter key but I don't know for sure.
|
|
|
|
Allen Kuo
|
| Posted: 06/04/2003, 7:18 PM |
|
You can reference:
http://www.atgconsulting.com/gofetch.asp
open a smaill new window and get the product description
If your client is IE5+, you can use XMLHTTP request server and get the response.
|
|
|
|
rclayh
|
| Posted: 06/05/2003, 3:46 AM |
|
Thanks for the example. I plan to dissect it. Could come in very handy in the future. Good job.
|
|
|
|
RonB
|
| Posted: 06/05/2003, 4:53 AM |
|
There is another way..
in the onchange event do a window.open() send the data entered as a parameter to the new page containing a query to the database. Use javascript to transport the result from the popup to the desired field and use self.close() to close the window on completion.
You could use opener.focus() to hide the popup during this proces.
Ron
|
|
|
|
