Datetime SQL

[RossM]

Hello,

I am designing a page in ASP and using MSSQL for the database. I want to use an if statement saying that if the field is empty, display something, else display something else.

However when i write:

If rsBoxEdit.Fields.Item("bFinishTime").Value = "" Then
response.write("Edit Finish Time")
Else
response.write("Finish Time Already has a Value")
End If

It say "Finish Time Already has a Value" when the field is blank.

The database saud the field is <NULL> if this helps and the field type is set to datetime.

Also if i put

If rsBoxEdit.Fields.Item("bFinishTime").Value <> "" Then
response.write("Edit Finish Time")
Else
response.write("Finish Time Already has a Value")
End If

It STILL says "Finish Time Already has a Value"

If someone could help that would be great. Anymore questions on the error please post them up.

Thanks,
Ross

[sashi]

Hi there,

Kindly refer to below code segment, hope it helps you to get started with, take care my fren.. :)

<%
  If rsBoxEdit.Fields.Item("bFinishTime").Value = vbNull Then
    response.write("Edit Finish Time")
  Else
    response.write("Finish Time Already has a Value")
  End If
%>