Re: Possible Problem with bind_param


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


Basically, it was the same code, but I just added the type parameter
to the bind_param call:
....
Just out of curiosity, what would "$dbh->{pg_server_prepare} = 0" do?

It forces the placeholders to get prepared by DBD::Pg, and not by Postgres
itself. Of course, it depends on what version of everything you have.
(please tell us that too). Either way, I can't see how anything in the code
you gave can transform what is clearly a string to an int without giving any
errors. Are you sure that $get_vars is returning what you think it does?
Have you tried setting $dbh->trace(10); before the block? It will produce
enough output to choke a hippopotamus, but should help narrow down the
problem by showing the exact output that DBI is receiving.

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

iD8DBQFFWza+vJuQZxSWSsgRAmItAKCohBee+582js64Z31FdJewAEkVPgCfWU+Z
avhkU/7XqXykbtmTLZmuqAg=
=PdXh
-----END PGP SIGNATURE-----


.