List:General Discussion« Previous MessageNext Message »
From:Tompkins Neil Date:April 6 2010 10:41am
Subject:Restricting data input
View as plain text  
Hi

I have a table that contains league standings type information for a soccer
league.  For example

season_id
round_id
team_id
league_id
home_won
home_draw
home_lost
home_goals
home_conceded
away_won
away_draw
away_lost
away_goals
away_conceded

Basically each row contains each league's round results for each team.  From
here I can display the league standings for each round for each league.  My
question is how / what is the best way to restrict incorrect data input
apart from a coding issue/bug - e.g I need to ensure that for each round a
team can only have either a value in the fields home_won or home_draw
or home_lost or away_won or away_draw or away_lost as a example.  Or is this
best coded within my application ?

Cheers
Neil

Thread
Restricting data inputTompkins Neil6 Apr
  • RE: Restricting data inputmisiaQ6 Apr