Hi all. In process of moving ASP apps from SQL server to Oracle using DTS mainly.
The app works fine with one exception, I have a conditional statement
if RS("Comment") = "" then
Response.Write "<td class=smShadeLite> " & RS("prepared") & "</td>"
The above code worked fine, in SQL Server. However, I am assuming because of the way oracle treats nulls this is not working. Please correct me if I am wrong, but do Oracle Null fields have to explicitly say "NULL"?
I have tried messing around with what is in the quotes and such but to no avail. The Comment field is nullable in the Oracle DB and I just cannot get this to work. Any insight is appreciated.