seeing if a field is empty 1

[derwent]

I need to look at a row in a DB, if it is null they need to fill it in

if trim(rs("thisfield")) = null then
response.write "you need to fill in this field"
end if

I have also tried if rs("thisfield") = "" then

but nothing is output. If I use 'if NOT rs("thisfield") = "" then response.write' on a row with data the response.write is printed so it is reading the row.

Am I having early morning stupidities?

 

[gmmastros]

I think this will solve your problem.

If IsNull(RS("thisfield")) Then
  Response.Write "you need to fill in this field"
End If

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom

 

[derwent]

thanks, will remember that one

 

[Sheco]

A database field could have either a NULL or a zero length string.

However if your ASP "requires" a value for this field, Neither Null nor the empty string may be acceptable.

Here is an easy way to test for both conditions at the same time:

If RS("thisfield") & "" = "" Then
  Response.Write "you need to fill in this field"
End If

That code works because when you combine Null with an empty string, the result is an empty string.