Test for null? [Archive]

wolfgang

04-11-01, 23:42

This ought to be easy, but I've been driving myself nuts with it...

I have a select statement that goes:

select template_name from agenda where group_name='"+group_ID+"' and meeting_date=null

which gives me all template names from the given group_ID, completely ignoring the meeting_date field.

I tried various permutations on 'null', "null", "", '', etc, but those would "blow up" the page TEST (none of the jsp stuff would show up, as it was stuck in a loop)

If you have a suggestion on how to select for all rows where a given field is null, I'd love to hear it... please e-mail that info to wolfgang<at>deathsdoor<dot>com

Regards,
Ron

Robi

04-12-01, 03:29

select template_name
from agenda
where group_name='"+group_ID+"'
and meeting_date is null

Alan Shein

04-12-01, 10:47

Try "is null" instead of "= null". Two different things altogether. You do not have a value that reads "null" (the actual characters making up the word, "null"), but you do have NULL values (values that have no value).