Hi,
I'm trying to setup some scripts that will allow me to use Perl DBI to
INSERT into my table. However, I have not had any success at all. I'm
using perl CGI as well so I've granted ALL permissions on my table to
the apache user and I still can't INSERT. I can, however, UPDATE and
SELECT on the table, just not INSERT.
Here is a piece of my code:
#--Establish the DB connection
#--Assign the DB name
$dbName = 'checkbook';
#--Connect to the Pg DB using DBI
my $dbh = DBI->connect("dbi:Pg:dbname=$dbName");
$sth = $dbh->do("INSERT INTO transactions
(date,description,amount,confirmation,nameid,typeid) VALUES
('$datePaid','$description','$amount','$confirmation',$nameid,$typeid)")
;
Please HELP...........
Thanks,
Mike
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
