PDA

View Full Version : Validation - If an value already exists in the dictionary/array

An Enigman
08-14-2009, 09:21 AM
Hey,

What I am trying to validate is that when the user submits the form, if there is a same name that already exists, it shows up with the error.

Here is the form:


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>asp footy form</title>
</head>

<body>
<h1>Footy Result Analyser</h1>
<p>__________________________________________________ ______</p>
<p>Please enter the team and player results in the form below.</p>
<p>Team 1 (Home):
<form method="post" action="FootyForm_P.asp">
<select name="team1" id="team1">
<option value="1" selected="selected">Adelaide Crows</option>
<option value="2">Brisbane Lions</option>
<option value="3">Carlton</option>
<option value="4">Collingwood</option>
<option value="5">Essendon</option>
<option value="6">Fremantle</option>
<option value="7">Geelong</option>
<option value="8">Hawthorn</option>
<option value="9">Melbourne</option>
<option value="10">North Melbourne</option>
<option value="11">Port Adelaide</option>
<option value="12">Richmond</option>
<option value="13">Saint Kilda</option>
<option value="14">Sydney Swans</option>
<option value="15">West Coast Eagles</option>
<option value="16">Western Bulldogs</option>
</select>
</p>
<table width="600" border="1">
<tr>
<td><div align="center">Player Name </div></td>
<td><div align="center">Goals</div></td>
<td><div align="center">Points</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_1_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_1_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_1_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_2_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_2_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_2_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_3_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_3_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_3_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_4_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_4_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_4_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_5_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_5_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_5_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_6_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_6_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_6_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_7_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_7_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_7_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_8_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_8_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_8_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_9_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_9_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_9_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_10_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_10_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_10_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_11_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_11_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_11_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_12_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_12_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_12_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_13_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_13_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_13_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_14_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_14_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_14_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_15_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_15_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_15_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_16_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_16_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_16_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_17_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_17_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_17_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_18_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_18_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_18_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_19_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_19_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_19_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_20_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_20_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_20_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_21_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_21_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_21_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
<tr>
<td><div align="center">
<input name="team_1_player_22_name" type="text" size="40" maxlength="40" />
</div></td>
<td><div align="center">
<input name="team_1_player_22_goals" type="text" size="2" maxlength="2" />
</div></td>
<td><div align="center">
<input name="team_1_player_22_points" type="text" size="2" maxlength="2" />
</div></td>
</tr>
</table>
<p>
<input type="submit" name="Submit" value="Submit" />
</p>
</form>
</body>
</html>


And here is what i have done for that bit so far:

Sub checkIfNameExistsTeam1()
Dim players_names(0,21), PlayerCount, item, d
PlayerCount = 0
For i = 1 To maxPlayers
If Trim(LCase(request.form("team_1_player_" & i & "_name"))) <> "" Then
players_names(0,PlayerCount) = Trim(LCase(request.form("team_1_player_" & i & "_name")))
PlayerCount = PlayerCount + 1
Else
PlayerCount = PlayerCount + 0
End If
Next
For i = 1 To maxPlayers -1
set d=Server.CreateObject("Scripting.Dictionary")
d.Add "key",players_names(0,i)
if d.Exists("key")= true then
Response.Write("Player exists."& d.Item("key"))
else
Response.Write("Player does not exist.")
end If
Next

End Sub


But obviously it doesn't work as right now with any name I enter and submit the form with, it says the name exists. Does anybody know how can I achieve this?

here is my php equivalent if it will help as it works:

function checkIfNameExistsTeam1()
{
$players_names = array();
for($i = 1; $i <= 22; $i++)
{
if(trim(strtolower($_POST['team_1_player_' . $i.'_name'])) != "")
{
$players_names[] = trim(strtolower($_POST['team_1_player_' . $i.'_name']));
}
}
$num_of_duplicates = array_count_values($players_names);
foreach($num_of_duplicates as $player => $key)
{
if($key > 1)
{
echo "The <b>player name " .$player. "</b> for <b>".team1($team)."</b> already exists.</b><br /><br />";

}
else
{
//Perform no action.
}
}
}


Thanks
An Enigman
08-14-2009, 12:41 PM
anyone? :(
Old Pedant
08-14-2009, 07:45 PM
Why bother to create the entry in the array only to then *also* add the entry to the dictionary???

Sorry...I don't get that at all.

And your way of using the dictionary is all wrong.


Sub checkIfNameExistsTeam1()
set players = Server.CreateObject("Scripting.Dictionary")
For i = 1 To maxPlayers
name = Trim(LCase(request.form("team_1_player_" & i & "_name")))
If name <> "" Then
If players.Exists( name ) Then
Response.Write "Duplicate name '" & name & "', player " _
& players(name) & " and player " & i & "<br/>"
Else
players.Add name, i
End If
End If
Next
End Sub


See? K.I.S.S.
An Enigman
08-15-2009, 06:34 AM
Thanks mate!

Worked perfectly!

I might need some more of your help soon.:)