Re: Test for null?

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

<wolfgang_at_123.com> wrote in message
news:n65adtole0b1u7odi48uj92jp51do7c97f_at_4ax.com...
> 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 - 15:47:16 CEST