Re: Test for null?

On Wed, 11 Apr 2001 22:42:09 -0400, wolfgang_at_123.com wrote:

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

select template_name from agenda where group_name='"+group_ID+"' and meeting_date is null Received on Thu Apr 12 2001 - 08:29:36 CEST