in reply to Re: Re: DBI + Bind
in thread DBI + Bind
Thats Exactly the problem.
I pass in an array to fill in all the bind variables
Some of the array is undef (ie NULL).
So when it reaches these it bombs out.
The only cure I had was to look at whether a field was
NULLABLE, and translate the code...
Ie UPDATE TABLE
SET ISNULL(field, "ZZZ") = ?
Then translate the undefs to ZZZ.... Not pretty
Kevman