in reply to Re: Need help with DBD::Pg
in thread Need help with DBD::Pg
You're right.
I tried with $dbh->{pg_server_prepare} = 1; but with no success too.
I tried with $dbh->{pg_server_prepare} = 1; but with no success too.
For me, that was a Big Change.
Answering your question, on another statement, I have:
This code was working before the upgrade. Now it's broken. It raises errors like the ones I posted before.$sql = "INSERT INTO tabreserves( date_reserve, hour_i, hour_e, date, fk_idclient, fk_idfield, fk_iduser,name_temp, value, vat_perc, vat_val,desc_perc, desc_val, total, nhours) VALUES(NOW(),?,?,?,?,?,?,?,?,?,?,?,?,?,?); SELECT currval('public.tabreserves_idreserve_seq'::text) $sth = $dbh->prepare($sql); $sth->execute( <values_goes_here> ); $sth->bind_columns(\(my $new_id_reserve)); $sth->fetch();
|
---|
Replies are listed 'Best First'. | |
---|---|
Re^3: Need help with DBD::Pg
by eclark (Scribe) on Feb 23, 2005 at 22:40 UTC | |
by Miguel (Friar) on Feb 23, 2005 at 23:11 UTC | |
by eclark (Scribe) on Feb 24, 2005 at 17:36 UTC | |
by Anonymous Monk on Feb 25, 2005 at 14:15 UTC |
In Section
Seekers of Perl Wisdom