Re: ILLUSTRA and WebDataBlade

In article <grimes.873253367@access5>, grimes@access5.digex.net (Seth Grimes) writes: > > 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. Yes, but you have to make sure that the value of $MI_NULL can't appear in the column you are interested in. -- Peter Haworth pmh@edison.ioppublishing.com "If UNIX is the revenge of the nerds, the rest of the industry is the football team and the cheerleading squad trying to produce a science project, and expecting to get an 'A' because they're the football team and the cheerleading squad." -- Fred Trottelhauer