Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Validate Form Data Against Database
- Thread starter Lambro
- Start date
Two ways to do this (possibly more):
(1) Build the page with ALL relevant part numbers saved to a JavaScript array and run a comparison with the onblur event from the textfield.
(2) Have a hidden iframe on the page and launch a check on the database there with the textfield's onblur event (my usual approach).
For example, the iframe might be:
partForm.html might be:
checkPartDatabase.jsp is whatever you have to do to run a check. If you want to pop-up a message at the end of it, then something like this could go there:
And if your parent page's textfield's onblur event calls a function (say 'checkPart()'), you will need this in the JavaScript of the parent page:
'hope that helps.
--Dave
(1) Build the page with ALL relevant part numbers saved to a JavaScript array and run a comparison with the onblur event from the textfield.
(2) Have a hidden iframe on the page and launch a check on the database there with the textfield's onblur event (my usual approach).
For example, the iframe might be:
Code:
<iframe id='checkPart' width='0' src='partForm.html'></iframe>partForm.html might be:
Code:
<html>
<body>
<form name='checkPartForm' action='checkPartDatabase.jsp'>
<input type='hidden' name='partNumber'>
</form>
</body>
</html>checkPartDatabase.jsp is whatever you have to do to run a check. If you want to pop-up a message at the end of it, then something like this could go there:
Code:
... <JSP code>
<html>
<head>
<script>
alert("Part number <%=partNumber%> is a <%=description%>");
this.location = partForm.html; //readies it for the next go
</script>
</head>
</html>And if your parent page's textfield's onblur event calls a function (say 'checkPart()'), you will need this in the JavaScript of the parent page:
Code:
function checkPart()
{
checkPartFrame.checkPartForm.partNumber.value = document.formName.textFieldName.value;
checkPartFrame.checkPartForm.submit();
}'hope that helps.
--Dave
- Status
Similar threads
- Locked
- Question
- Locked
- Question