Variables | Problems in the ASP useful Dim predefined variables are very good habits, but I encountered such a problem:
Use a stored procedure to take out a result set, one of which is the smalldate type, the default is null, and here is ' 2001-4-4 ', as follows:
...
<Table>
...
</Table>
<%
IF not IsNull (ORs ("E_dt")) Then
%>
<Table>
...
</Table>
<%
End IF
%>
The date that can be displayed is 1899-12-30.
Before the Judgment plus Response.Write oRs ("E_dt") incredibly empty.
Later, read:
<%
Dim Strback
IF IsNull (ORs ("E_dt")) Then
Strback = "0"
Else
Strback = "1"
End IF
%>
...
<Table>
...
</Table>
<%
IF strback = "1" Then
%>
<Table>
...
</Table>
<%
End IF
%>
On the right, before the Judge plus Response.Write ORs ("E_dt") also shows normal.
It is strange that you should be careful when using dim, and would rather add a few more variables.
