Jim Cain <jec@mgmt-inc.com> wrote:

...

Jim, are you by any chance using Brian Hooper's Sybase DA? If so, please note that this DA handles null values poorly out of the box. I have a simple patch that fixes this and other somewhat severe problems with this DA.

Nope, I'm using the MySQL DA.

I think it's a bug, Jim. I've been playing with the same = <dtml-if column1> <dtml-var column1 null=""><BR> </dtml-if> This also displays NULL ! Which means both the dtml-if and the default null value are failing to recognise the null value in my variable 'column1'. Henry, ____________________________________________________________________ Get free email and a permanent address at http://www.netaddress.com/?N=1