Reading a Boolean field from an SQL database.

Calltronics

i am reading an SQL table and its working fine.
However if i simple read a boolean colomn "IsBaseLine" from the same SQL table. (the boolean data : "IsBaseLine",)
Then I get an error:
DataTables warning: table id=tblData - Requested unknown parameter 'IsBaseLine' for row 0, column 0. For more information about this error, please see http://datatables.net/tn/4
I've read around in circles trying to render and test the (data) but to no avail.
Can anyone help?

tangerine

Did you follow the diagnostic process outlined at the provided link?

Calltronics

The link provides yoiu detail on the fact that the data could not be read.
This is not the case the date is there and readable. ie true/false.
If I change the data to say string the column is readable. Just won't read SQL boolean (bit)

allan

Can you use the debugger to give me a trace please - click the Upload button and then let me know what the debug code is.

Allan

Calltronics

https://debug.datatables.net/idades

allan

Thanks!

In your JSON:

"isBaseLine": false

but your comment above:

IsBaseLine

the i is a different case. That might be the issue?

Allan