From: | "Kovalcik, Mike A [ITS]" <mkoval01(at)sprintspectrum(dot)com> |
---|---|
To: | <pgsql-admin(at)postgresql(dot)org> |
Subject: | Perl DBI question |
Date: | 2003-06-17 21:51:33 |
Message-ID: | 480641561E05E94D9B6CCE1E39AA0300116792@PDAWB06C.ad.sprint.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Taranjit Singh Lamba | 2003-06-17 21:53:20 | postgreSQL 7.3.3 crashing on server with Itanium processor... |
Previous Message | Jonathan Gardner | 2003-06-17 20:37:37 | Re: Can the frontend get notifications from the postgres server? |