Not Null Database Condition

[Bhupinder Chawla]

Hi,

In the Where condition, I have the following JavaScript:

var E = localStorage.getItem('local_EventID');
var S = "not null";
return '{"EventID":"'+E+'", "Score":"'+S+'"}';

It gives me no data (even though many records exist). Please note Score can be LESS THAN 0, ZERO, or GREATER THAN 0.

I want to eliminate NULL values from the results.

Thanks!

Best Regards
Bhupinder Chawla

[Alena Prykhodko]

Hi,

Where exactly do you run this condition?
Also please show us a few rows from your database.