--- trunk/lib/App/RoomReservation/Confirmation.pm 2009/07/01 22:25:11 1152 +++ trunk/lib/App/RoomReservation/Confirmation.pm 2009/07/02 10:12:54 1155 @@ -33,6 +33,7 @@ where md5(id||email) = ? and _confirmed is false + and _canceled is false }); $sth->execute( $self->token ); @@ -68,7 +69,7 @@ my $sth = $dbh->prepare(qq{ update reservation set - _confirmed = false, + _canceled = true, _seat_number = null where md5(id||email) = ?