Test for null?

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 --- (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

(Notice to spammers: spam is not welcome)

Regards,

Ron Received on Thu Apr 12 2001 - 04:42:09 CEST