Object doesn't support property or method 'column'

pfiorella

Object doesn't support property or method 'column'

I get this error trying to run the following code:

var name = $("#monthFilter option:selected").text();
table.column(7).search(name).draw();

Before you tell me to read the FAQs, I did check to make sure I'm using the correct initialization of the table, that is:

 var table = $('#tblForecast').DataTable();

as opposed to:

var table = $('#tblForecast').dataTable();

And still no luck. Am I missing something obvious?

Daimian

Your correct, you are using it correctly.
My only thought was you are accidentally overwritting table variable after initialization?

pfiorella

Here's my entire script:

<script type="text/javascript">

    $(document).ready(function () {
        var table = $('#tblForecast').DataTable({
            "sPaginationType": "full_numbers",
            "bJQueryUI": true,
            "fnDrawCallback": calculateTotal,
            "bPaginate": true,
            "iDisplayLength": 100
        }); //end table init



        $('#monthFilter').change(function () {
            var name = $("#monthFilter option:selected").text();
            if (name !== "No Filter") {
               table.column(7).search(name).draw();
            } else {
                table.column(7).search("").draw();
            }
        }); //end change

    });//end ready

</script>

pfiorella

I figured it out. I have 3 separate instances of DataTables on the same page and they had conflicting code, doh! Thanks!