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