Data validation via vbscript 1

Terpsfan · Dec 2, 2002

I know in vb you can loop through all the controls on a form and check to see if none are null, before trying to update the database, but not sure how this could be done via vbscript or html. In vb it goes like this:

Dim ctl as Control
For Each ctl in Form.controls
If TypeOf ctl Is TextBox Then
If IsNull(ctl) Then
MsgBox "Enter data here"
ctl.SetFocus
End If
End If
Next ctl

onpnt · Dec 2, 2002

you ahve two options really here. you can do a loop after the form is submitted and write all null or "" objects to the screen
example something like
Dim obj
For Each obj In Request.Querystring
If Request.QueryString(obj) <> "" Then
'Do something
End If
Next

or much easier you can keep it client side with a simple function after the user submits the form
example in javascript
<html>
<head>
<script>
function validate(){
frmLength = document.frm.length;
var errorHandle = false;
var fldName = "The following form fields must be entered\n";
for (i=0; i<frmLength;i++){
if(document.frm.value == "&quot
fldName += document.frm.name + "\n"
errorHandle = true;
}

if(errorHandle) {
alert(fldName);
return false;
} else {
return true;
}
}
</script>
</head>
<body>
<form name="frm" onSubmit="validate()">
<input type="text" name="txt1">
<input type="text" name="txt2">
<input type="text" name="txt3">
<input type="text" name="txt4">
<input type="text" name="txt5">
<input type="text" name="txt6">
<input type="submit" value="submit">
</form>
</body>
</html> I dare to learn more

http://www.onpntwebdesigns.com
admin@onpntwebdesigns.com

onpnt · Dec 2, 2002

not only did the italics bandit get me I forgot the return in the call event
change the form tag to read
onSubmit="return validate()"
and this is the code without the italics in there (sorry about that)
<script language="javascript">
function validate(){
frmLength = document.frm.length;
errorHandle = false;
var fldName = "The following form fields must be entered\n";
for (i=0; i<frmLength;i++){
if(document.frm.value == "&quot {
fldName += document.frm.name + "\n"
errorHandle = true;
}
}
if(errorHandle) {
alert(fldName);
return false;
}
else
{
alert("the form was found error free"
return true;
}
}

</script> I dare to learn more

http://www.onpntwebdesigns.com
admin@onpntwebdesigns.com

GabeC · Dec 3, 2002

Even if you do your checking client side, which is a great idea to keep round trips to the server down, you should also conduct the same validation on the server. Some browsers don't support JavaScript and even those that do, the user can turn it off.
Thanks,

Gabe

onpnt · Dec 3, 2002

Also i wanted to add, I see you have a msgbox in your VB code and incase you try to incorpurate this into your vbscript via server side (ASP) validating you cannot use this function. Unfortunetly alerts and msgbox's are not available to us in ASP. There are ways around it with the use of popups etc.. so don't be discouraged by it. Personaly always thought a well formatted popup is always more appealing to the user and developer then a simple alert I dare to learn more

http://www.onpntwebdesigns.com

admin@onpntwebdesigns.com

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!

Data validation via vbscript 1

Terpsfan

Programmer

onpnt

Programmer

onpnt

Programmer

GabeC

Programmer

onpnt

Programmer

Similar threads

Part and Inventory Search

Sponsor