From 2e5564d2fd86d3ea6cbdbdb67022f7adae3fc585 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Bj=C3=B8rn=20Rustad?= Date: Thu, 15 Aug 2013 21:26:51 +0200 Subject: [PATCH] Delete old team when editing team --- lib/Duplo/Manager.pm | 9 +++++++++ 1 file changed, 9 insertions(+) diff --git a/lib/Duplo/Manager.pm b/lib/Duplo/Manager.pm index f766d7c..20553ee 100644 --- a/lib/Duplo/Manager.pm +++ b/lib/Duplo/Manager.pm @@ -205,6 +205,15 @@ sub edit { return $self->redirect_to('manager_team', team => $team) } + $dbh->do(" + DELETE FROM + rider_manager_team + WHERE + manager_team = ? + AND + stage = ? + ", undef, $team, $stage); + my $sth = $dbh->prepare(" INSERT INTO rider_manager_team (rider, manager_team, stage) -- 2.47.3