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] |