in reply to DBI + Binds?

$sth->prepare($query);
$sth->execute();

[download]

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

    I know how to do it thanks - the problem is the code is not working with an update bind

    Kevman
[reply]
      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

[reply]
[d/l]
[select]

        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]

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

        Thanks for asking though :)

        Kevman
[reply]

In Section Seekers of Perl Wisdom