$NaN in Integer Column for Null Values

DanOsh

Hi All, first, just found this site and the Editor today and it is something I've been trying to find. It is a great way to get into personalizing and customizing data on the web.

I have a test page I mirrored the simple example at www.skywateryachts.com/datatables_editor/examples/simple/boats.html.

I'm getting in the Listing Price column cells with $NaN where they are Null in the MySql table. Any idea how I can make these tables empty?

Thank you.

allan

Hi,

I've just committed a little change to DataTables that will allow this to work correctly. Could update your DataTables Javascript include to pull in the nightly version. Also, you will need to use columns.defaultContent to specify what you want to appear in the cells where there null data - for example:

{
  data: "Listing_Price",
  render: $.fn.dataTable.render.number( ',', '.', 0, '$' ),
  defaultContent: "Price on request"
},

The change I've made in DataTables is to allow the renderer to pass the null value back - which means that the defaultContent can be used.

Regards,
Allan

DanOsh

Hi Allan,

Thank you for the prompt reply. I did apply the nightly downloads, but the area I'm working on is in the 'Editor' folder's .js and .css files and it appears those are not the same. Which brings me to ask, is there a right or wrong of uploading the editor in a separate folder or should it be uploaded under the 'datatables' folder? Initial glance tells me it doesn't matter.

And how do the nightly updates work for the 'datatables' and the 'datatables editor'? I would think on a change to one, there would be a change to the other.

I'm working on table builds for both public/private tables and an admin area.

http://www.skywateryachts.com/datatables_editor/examples/simple/boats.html

Thanks,

Dan

allan

Hi Dan,

In the page's source change:

//cdn.datatables.net/1.10.5/js/jquery.dataTables.min.js

to:

//datatables.net/download/build/nightly/jquery.dataTables.min.js?_=8ad39b7e0f90575b20da99d7495efa87

To use the nightly version of DataTables.

I would think on a change to one, there would be a change to the other.

Not in this case :-). Sometimes Editor will require a specific version of DataTables, but I try to enforce such as change as little as possible.

Allan

DanOsh

Ok. Well done. Did the job!

Love this application. Best I've seen around. This is more hands on to learn working with data.

Fast response and the forum is exhaustive and responsive.

All together it convinces me to purchase the editor!

I can't wait to get deep into all the code and extensions.

Thanks for a great product!

Dan

allan

Good to hear that did the job for you, and thank you for your kind words :-)

Allan

DanOsh

You're very welcome. It was deserved.