Re: Perl DBI question

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: "Kovalcik, Mike A [ITS]" <mkoval01(at)sprintspectrum(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Perl DBI question
Date: 2003-06-18 17:46:48
Message-ID: 20030618174648.GA22260@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Jun 17, 2003 at 16:51:33 -0500,
"Kovalcik, Mike A [ITS]" <mkoval01(at)sprintspectrum(dot)com> wrote:
>
> $sth = $dbh->do("INSERT INTO transactions
> (date,description,amount,confirmation,nameid,typeid) VALUES
> ('$datePaid','$description','$amount','$confirmation',$nameid,$typeid)")
> ;

Most likely you want single quotes around $nameid and $typeid.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message greg 2003-06-18 17:47:59 Re: Perl DBI question
Previous Message Jeremy Buchmann 2003-06-18 17:44:10 Re: Perl DBI question