validate form for any selection on submit

philrm · Feb 4, 2002

Hi ALL

We are trying to validate a form on submit. I want to check all of the input fields to make sure at least one of them has been changed. This will avoid the query extracting ALL recordes from the table.

Below is the form code I am using. Can anyone provide the code to do this validation? The four input field names are asc_order_cd, site_number, surveyorone, proj_code and factual_key as shown in the code below.

<form name="" method="post" action="testtwo.cfm">
<table width="673" border="0" height="179">
<tr>
<td>ASC:</td>
<td>
<select name="asc_order_cd">
<option value="allasc" selected>(All Asc)
<cfoutput query="order">
<option value="#code# ">#code# |#description#
</cfoutput>
</select>
</td>
</tr>
<tr>
<td>Site Number:</td>
<td>
<input type="text" name="site_number">
</td>
</tr>
<tr>
<td>Surveyor One:</td>
<td>
<select name="surveyorone">
<option value="allsurveyor" selected>(All Surveyors)
<cfoutput query="sureone">
<option value="#surveyor_code# ">#surveyor_code# | #surveyor_last_name#
</cfoutput>
</select>
</td>
</tr>
<tr>
<td>Project Code:</td>
<td>
<select name="proj_code">
<option value="allprojects" selected>(All Projects)
<cfoutput query="projectcode">
<option value="#project_code# ">#project_code# | #project_title#
</cfoutput>
</select>
</td>
</tr>
<tr>
<td>Factual Key:</td>
<td>
<select name="factual_key">
<option value="allfactualkey" selected>(All Factual Keys)
<cfoutput query="factualkey">
<option value=" #code# ">#code# |#description#
</cfoutput>
</select>
</td>
</tr>
</table>
<p>
<input type="submit" value="Find a matching soil">
</p>
</form>

elegidito · Feb 4, 2002

hmm..try something like this:

Code:

<script language="javascript"></script> <body> <select onChange="validate()"> <input type="submit" value="Find a matching soil"> </form> </body> </i>

Hope it helps.

matt

elegidito · Feb 4, 2002

need ta put something in...

**

<body>
<form onSubmit="checkValidation()" method="post" action="testtwo.cfm">
<select onChange="validate()">
<option>soforth</option>
</form>

**

stuff in red needs added (i hope..im very tired .. lol)

philrm · Feb 4, 2002

HI Dookie2k2

The code you gave me is only half functioning. What it is doing is that when, you click on this button command <input type="submit" value="Find a matching soil" >
IT comes up with only the alert message and then when I click OK it still process the query. It doesn't allow for a user to select a validate information before submitting it . What is going on here ?

<script language="javascript"><!--
function validate()
{
var validate = "validated"
}
function checkValidation()
{
if (validate == "validated&quot

document.myForm.submit // eh..i forgot the auto-submit dealio
else
alert("Change Something&quot

;
}

//-->
</script>

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<form name="myForm" method="post" action="testtwo.cfm" onSubmit="checkValidation();">
<table width="673" border="0" height="179">
<tr>
<td>ASC:</td>
<td>
<select name="asc_order_cd" onChange="validate()">

<option value="allasc" selected>(All Asc)
<cfoutput query="order">
<option value="#code# ">#code# | #description#
</cfoutput>
</select>
</td>
</tr>
<tr>
<td>Site Number:</td>
<td>
<input type="text" name="site_number" onChange="validate()">
</td>
</tr>
<tr>
<td>Surveyor One:</td>
<td>
<select name="surveyorone" onChange="validate()">
<option value="allsurveyor" selected>(All Surveyors)
<cfoutput query="sureone">
<option value="#surveyor_code# ">#surveyor_code# | #surveyor_last_name#
</cfoutput>
</select>
</td>
</tr>
<tr>
<td>Project Code:</td>
<td>
<select name="proj_code" onChange="validate()">
<option value="allprojects" selected>(All Projects)
<cfoutput query="projectcode">
<option value="#project_code# ">#project_code# | #project_title#
</cfoutput>
</select>
</td>
</tr>
<tr>
<td>Factual Key:</td>
<td>
<select name="factual_key" onChange="validate()">
<option value="allfactualkey" selected>(All Factual Keys)
<cfoutput query="factualkey">
<option value=" #code# ">#code# |#description#
</cfoutput>
</select>
</td>
</tr>
</table>
<p>
<input type="submit" value="Find a matching soil" >
</p>
</form>
</body>
</html>

elegidito · Feb 5, 2002

here we go -- this script assumes that the value of the select box is 1 thing. (in other words, it cant really tell if it changes, only if it stays the same (confusing eh))

Code:

[b]
<script language=&quot;javascript&quot;><!--
function checkValidation()
{
validate = document.form1.select1.value;
if (validate == &quot;change&quot;)
alert (&quot;You must change something&quot;);
else
document.form1.submit;
}
//--></script>
<form name=&quot;form1&quot;>
<select name=&quot;select1&quot;>
<option value=&quot;change&quot;>change me</option>
<option value=&quot;changed&quot;>changed</option>
</select>
<input type=&quot;button&quot; value=&quot;gooooo&quot; onClick=&quot;checkValidation()&quot;>
</form>

[/b]

philrm · Feb 5, 2002

Hi Dookie2k2

Anyway thank's for your help. I found a much simpler and fully functional validation for this problem. I need this to be fix by yesterday, so therefore I could not wait this long for your final reply. Thank's anyway!

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!

validate form for any selection on submit

philrm

MIS

elegidito

Programmer

elegidito

Programmer

philrm

MIS

elegidito

Programmer

philrm

MIS

Similar threads

Part and Inventory Search

Sponsor