--- branches/zimbardo/lib/App/RoomReservation/Confirmation.pm	2009/07/07 20:53:55	1180
+++ branches/zimbardo/lib/App/RoomReservation/Confirmation.pm	2009/07/07 22:07:51	1181
@@ -16,6 +16,8 @@
 
 	my $dbh = $self->dbh;
 
+	my $size = $self->room->seats;
+
 	my $sth = $dbh->prepare(qq{
 		update reservation
 		set
@@ -23,7 +25,7 @@
 			_seat_number = (
 				select
 				        min(seat.nr)
-				from (select generate_series(1,600) as nr) as seat
+				from (select generate_series(1,$size) as nr) as seat
 				full join reservation on reservation._seat_number = seat.nr
 				where id is null
 				group by seat.nr