Test for null?

#1 (**permalink**) 04-11-01, 22:42

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

I have a select statement that goes:

Code:

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

#2 (**permalink**) 04-12-01, 02:29

Code:

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

#3 (**permalink**) 04-12-01, 09: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).

Internet Services

Web Development

Digital Marketing

Consumer Tech