Data Tables Coldfusion

Data Tables Coldfusion

mariozmarioz Posts: 9Questions: 0Answers: 0
edited November 2010 in General
Can anyone help me with getting this set up with coldfusion, i am using sql server and want to be able to pull the data from the database, similiar to the php example that is on here... i know its a pain but am a bit desperate to get it working with coldfusion until we migrate across to PHP.



Many thanks in advance

Replies

  • allanallan Posts: 63,761Questions: 1Answers: 10,510 Site admin
    This might be useful: http://datatables.net/development/server-side/coldfusion

    Allan
  • mariozmarioz Posts: 9Questions: 0Answers: 0
    Many thanks for that Allan... i'm struggling to get it started.. i have created the script and i am using the following script to call it


    $(document).ready(function() {
    $('#example').dataTable( {
    "bProcessing": true,
    "bServerSide": true,
    "sAjaxSource": "getData.cfm"
    } );
    } );


    but i get the following javascript error;

    "DataTables warning: JSON data from server could not be parsed. This is caused by a JSON formatting error."

    any ideas?
  • mariozmarioz Posts: 9Questions: 0Answers: 0
    by the way... i'd like to use sql server..

    cheers
  • allanallan Posts: 63,761Questions: 1Answers: 10,510 Site admin
    I'd suggest asking in a ColdFusion based forum, as this is primarily frequented by Javascript people like myself, rather than ColdFusion (or whatever other server-side language). I don't know ColdFusion myself, so I doubt I'd be able to help. All I can suggest is to look at the XHR return in Firebug and see what it says - normally there will be an indication where the error is.

    Allan
This discussion has been closed.