You really ought to a placeholder for $self->{id} instead of pasting the
value into the SQL.
I don't think the $end_date in your SQL is doing what you expect.
--
Mac :})
** I normally forward private questions to the appropriate mail list. **
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.
----- Original Message -----
On Mon, 16 Jul 2001, Barry Hoggard wrote:
> I know in Oracle I do something like this:
>
> my $sth = $self->dbh->prepare(qq{ update users set
> valid=0,end_date=sysdate
> where id='$self->{id}' returning
> $end_date
> into :1});
>
> Is this possible with DBD::Pg?
