Re: ILLUSTRA and WebDataBlade

Posted in 1997

Seth Grimes — 2 Sep 1997 22:24:16 -0400 — source: Informix-list mailing list archive (1991-1998)

Olivier FERNANDEZ <ofernandez@icor.fr> writes: >What's the procedure to test if an variable is a null ? >(Ex: ><?MISQL SQL="Select var1, var2, var3 from .... where ...;"> > and I want to know if an return a $2 is null or blank) Checking MI_ROWCOUNT won't do since there may be rows with NULL values. What you should do is check whether $2 == $MI_NULL. Refer to the manual for exact $MI_NULL spelling. Seth -- Seth Grimes -- grimes@access.digex.net -- http://www.access.digex.net/~grimes grimes@magnet.com -- http://www.magnet.com