RE: Possible Problem with bind_param


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


Philip Garrett:
FWIW, I tested a simple "SELECT ?" with your '341_43392s@xxxxxxxxxxxxx'
value against my Postgres 7.2 (DBD::Pg 1.21). It bound fine and
returned the correct value.

Yikes! Please update both of those right away - they are severely
old and unsupported. Might want to check DBI as well. :)

David Wu wrote:
Thanks for the suggestion. I thought that might be the case as well,
and I've already tried adding the type attribute as a varchar, but
there was no change.

Can you show us the code you used to do so? You might also try this
variant and see if it helps:

$dbh->{pg_server_prepare} = 0;
my $sql = "UPDATE m_user SET email = ?, first_name = ?, last_name = ? WHERE id = ?";
my $sth = $dbh->prepare($sql);

- --
Greg Sabino Mullane greg@xxxxxxxxxxxx
PGP Key: 0x14964AC8 200611122008
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----

iD8DBQFFV8ePvJuQZxSWSsgRArF8AJ94D9ytn1HhGQgq1PgvJ3JkoBjmVQCg6yJU
DJ9RMVFEKI8qw90z4YVwPkY=
=yXRj
-----END PGP SIGNATURE-----


.

Relevant Pages