problem with 'Check to see if a string is numeric function' and fnSetColumnVis api

problem with 'Check to see if a string is numeric function' and fnSetColumnVis api

deng.zzdeng.zz Posts: 2Questions: 0Answers: 0
edited May 2010 in Bug reports
1.[code]
function(sData) {
/* Sanity check that we are dealing with a string or quick return for a number */
if (typeof sData == 'number') {
return 'numeric';
}
else if (typeof sData.charAt != 'function') {
return null;
}

var sValidFirstChars = "0123456789-";
var sValidChars = "0123456789.";
var Char;
var bDecimal = false;

/* Check for a valid first char (no period and allow negatives) */
Char = sData.charAt(0);
if (sValidFirstChars.indexOf(Char) == -1) {
return null;
}

/* Check all the other characters are valid */
for (var i = 1; i < sData.length; i++) {
Char = sData.charAt(i);
if (sValidChars.indexOf(Char) == -1) {
return null;
}

/* Only allowed one decimal place... */
if (Char == ".") {
if (bDecimal) {
return null;
}
bDecimal = true;
}
}

return 'numeric';
},
[/code]
this function, if sData is null, it will throw exception.
2.
[code]

oTable.fnSetColumnVis($("#mycheck").val(), true);
[/code]
it doesn't work.i have to use it like this:
[code]

oTable.fnSetColumnVis(Number($("#mycheck").val()), true);
[/code]

thank you!

Replies

  • allanallan Posts: 57,300Questions: 1Answers: 9,127 Site admin
    The reason for this "problem" is that DataTables currently doesn't allow null data. Null is an absence of data - not and empty string, not 0 nothing - so how does one display nothing in a tabular form... This is why it is not currently supported - however, it will be with DataTables 1.7, as quite a lot of people such as yourself want to display null data :-).

    Regards,
    Allan
This discussion has been closed.