what's wrong with this statement

[tonny]

I want to use a statement that checks a field (in access)<br>
called &quot;naam&quot; and when it's empty it should perform an action:<br>
<br>
&lt;% if rsProds(&quot;naam&quot = &quot;&quot; then %&gt;<br>
field empty<br>
&lt;% Else %&gt;<br>
<br>
field not empty<br>
<br>
&lt;% End If %&gt; <br>
<br>
But when this field is empty, this statement handles it like it's not empty<br>
<br>
Can anyone solve this problem?<br>
<br>
greetings,<br>
<br>
Tonny Wijnand <br>

 

[calahans]

Hi Tonny,<br>
<br>
I think your problem maybe to do with NULL values, NULL is not the same as ''. An RDBMS will insert NULL rather then '' if you don't specify a value on insertion.<br>
<br>
I think there is a function ISNULL which you can use to check this.<br>
<br>
HTH<br>
<br>
C