if (iEmpID ==""){
    objParam1.value=null;
 if dateFrom = "" then
    strUpdate = strUpdate + " and dtRateFrom is null"

  if resType="E" then
    strEmpID = cstr(iEmpID)
    strSubID = "null"
Please let me know what is the difference between is null and =null and "null" As shown above why I am using three different cases of null
in the above three codes. Please help me. I will appreciate your suggestions and comments. Thanks

Hi,

  var n1,n2=null,n3=="null";

  n1 is declared but not initialised so it is equivallent to null.
n2 is assigned null.
n3 is string variable contains value "null". Its not eq to null.

if(n1==null){
    alert("n1 is null");
}
if(n2==null){
    alert("n2 is null");
}
if(n3=="null"){
    alert("n3 is \"null\");
}



------------
Rajani

Use is null when checking the status of a field in sql:

select * from table where field1 is null

Use = null when assigning

update table set field1 = null

"null" is a string value that says null.

Brian

Hi Shoakat,

Did you do a search on this here, you would find a handfull of such threads discussed on that NULL subject that should be useful to you.

Cheers!

_________________________
- Vijay G
Strive for Perfection