(E-mail)
Subject: Calculation the total of my column
List,
I have a problem here that I am having a little bit of trouble trying to
resolve. Firstly I have a Perl script that connects to a PostgreSQL
database using the DBI module. I want to be able to SELECT a column from
the database and return
I would do it like this (taking a stab at this...critique is welcomed):
At 03:17 PM 08.16.2001 +0930, Daniel Falkenberg wrote:
>List,
>
>I have a problem here that I am having a little bit of trouble trying to
>resolve. Firstly I have a Perl script that connects to a PostgreSQL
>database using t
Dan, :)
$sth = $dbh ->prepare( qq{ SELECT SUM(time_track_minutes)
FROM table
WHERE status = 'COMPLETE'
} ) || die $dbh->errstr; ;
$sth->execute;
Regards,
Daniel Fal
List,
I have a problem here that I am having a little bit of trouble trying to
resolve. Firstly I have a Perl script that connects to a PostgreSQL
database using the DBI module. I want to be able to SELECT a column from
the database and return the total result.
For example if I do the follow