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
To: [EMAIL PROTECTED]
Sent: 07/16/2001 10:42 AM
Subject: Returning a value from insert/update with DBD::Pg
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
On Mon, Jul 16, 2001 at 11:05:10AM -0600, Sterin, Ilya wrote:
What are you trying to do. Placeholder binding? Are you asking if you can
run such a query? I don't see anything specific to Oracle here, unless
DBD::Pg does not support named placeholder, then you will have to use ?
instead of
11:11 AM
Subject: Re: Returning a value from insert/update with DBD::Pg
On Mon, Jul 16, 2001 at 11:05:10AM -0600, Sterin, Ilya wrote:
What are you trying to do. Placeholder binding? Are you asking if
you can
run such a query? I don't see anything specific to Oracle here,
unless
DBD::Pg does
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