Page 1 of 1

Not Null Database Condition

Posted: Sat May 02, 2015 10:00 am
by 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


Not Null Database Condition

Posted: Sun May 03, 2015 11:15 am
by Alena Prykhodko

Hi,

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