[peejay]

how would you know that there is no value in the database field you have retrieved? I have a code here and it doesn't work:

<%
If oRs.Fields("projmgr") = "" Then
response.Write("No Selection")
Else
response.Write oRs.Fields("projmgr")
End If
%>

[Naresh Rohra]

Your code should work. But sometime (may be) it depends on the field’s Datatype. Try with some functions like IsEmpty, IsNull, IsDate etc.

[Mikeirv]

if you do this:

<%
If oRs.Fields("projmgr") & "" = "" Then
response.Write("No Selection")
Else
response.Write oRs.Fields("projmgr")
End If
%>

it will work no matter what the data type

[peejay]

thanks mikeirv. It worked!