in reply to Re: Re: DBI + Binds?
in thread DBI + Binds?

What values are in @array? If there is an undef, this won't work properly: undef is translated to an SQL null and comparisons must be made with the IS operator, eg field1 is null because field1 = null will always be false.

rdfield

Replies are listed 'Best First'.
Re: Re: Re: Re: DBI + Binds?
by Kevman (Pilgrim) on May 27, 2002 at 13:22 UTC

    That was exactly the problem!!! Many ++++++ to you!!

    took me 4 hours to fix!!

    Thought I'd cleared the nulls - but alas no

    It was translated '' as a NULL I think???

    Many Thanks

    Kevman
[reply]
Re: Re: Re: Re: DBI + Binds?
by Kevman (Pilgrim) on May 27, 2002 at 12:18 UTC

    No undefs - Just an array of fields - I replace undefs with blank

    Thanks for asking though :)

    Kevman
[reply]

In Section Seekers of Perl Wisdom