Changeset 303
- Timestamp:
- 05/17/10 23:27:27 (14 years ago)
- Files:
-
- 3 edited
- 1 copied
Legend:
- Unmodified
- Added
- Removed
-
branches/1/lib/Vote/Model/Vote.pm
r302 r303 144 144 my @online_f = qw(label start end owner password); 145 145 146 $self->db->do(q{set DATESTYLE to 'DMY'});146 # $self->db->do(q{set DATESTYLE to 'DMY'}); 147 147 if (grep { exists($attr{$_}) } @online_f) { 148 148 my $sth = $self->db->prepare_cached( -
tags/1.01/lib/Vote/Model/Vote.pm
r302 r303 144 144 my @online_f = qw(label start end owner password); 145 145 146 $self->db->do(q{set DATESTYLE to 'DMY'});146 # $self->db->do(q{set DATESTYLE to 'DMY'}); 147 147 if (grep { exists($attr{$_}) } @online_f) { 148 148 my $sth = $self->db->prepare_cached( -
trunk/lib/Epoll/DB.pm
r272 r303 215 215 my ($self, $mail) = @_; 216 216 $mail or return; 217 my $finder = $self->db->prepare_cached( 218 q{select poll, date from voting left join signing 219 on voting.key = signing.key 220 where mail = lower($1) 221 order by date desc 217 my $finder = $self->db->prepare_cached(q{ 218 select poll.id, date from poll join 219 subpoll on poll.id = subpoll.pollid 220 join voters on voters.poll = poll.id 221 left join signing on 222 signing.subpoll = subpoll.id and 223 signing.voters = voters.key 224 where mail = lower($1) 225 group by poll.id, date 226 order by date desc 222 227 } 223 228 );
Note: See TracChangeset
for help on using the changeset viewer.