dealing with null values from JSON source

[m0j0r1s1ngParticipant]

Hi

I have a mySQL query that does a divide by zero (in some cases) and therefore writes a NULL to that column for the row.

When bringing it into my jqDataAdapter (for later use in Grid and Chart), I want it to treat NULL like 0 so that I don’t get blanks in my grids and discontinuous lines in my charts.

Any ideas on this?

[Peter StoevKeymaster]

Hi m0j0r1s1ng,

You can update the data before loading it into the widgets by using the jqxDataAdapter’s “beforeLoadComplete” callback. For more details about it, please look at: http://www.jqwidgets.com/jquery-widgets-documentation/documentation/jqxdataadapter/jquery-data-adapter.htm

Best Regards,
Peter Stoev

jQWidgets Team
http://www.jqwidgets.com/

[m0j0r1s1ngParticipant]

Thank you, that was just the hint I was looking for!

I have asked 2 questions on here so far and have been very pleased with your quick support. I wanted to let you know that the help is VERY much appreciated.

Are you guys interested in seeing the projects using jqw?

[Author]

Posts