summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rwxr-xr-xLedgerSMB/Form.pm7
1 files changed, 5 insertions, 2 deletions
diff --git a/LedgerSMB/Form.pm b/LedgerSMB/Form.pm
index 8cc59544..f15ee00a 100755
--- a/LedgerSMB/Form.pm
+++ b/LedgerSMB/Form.pm
@@ -1490,6 +1490,7 @@ sub db_init {
$self->{dbh}->do( $date_query{ $myconfig->{dateformat} } );
$self->{db_dateformat} = $myconfig->{dateformat}; #shim
+ #$self->{dbh}->do('set log_statement to \'all\'');
my $query = "SELECT t.extends,
coalesce (t.table_name, 'custom_' || extends)
@@ -2159,8 +2160,10 @@ sub all_years {
# get years
my $query = qq|
- SELECT (SELECT MIN(transdate) FROM acc_trans),
- (SELECT MAX(transdate) FROM acc_trans)|;
+ SELECT (SELECT transdate FROM acc_trans ORDER BY transdate asc
+ LIMIT 1),
+ (SELECT transdate FROM acc_trans ORDER BY transdate desc
+ LIMIT 1)|;
my ( $startdate, $enddate ) = $dbh->selectrow_array($query);