Update JQUERY DATATABLE CELL In Database using Coldfusion and Ajax

Viewed 110

I am trying to update my database table values from form docTableID into our database found in masterMaint.cfc. I seem to be stuck on the ajax post method where I want to POST the client side changes to the database when onUpdate is called.

masterMaint.cfc

<cfcomponent output="false">
    <cffunction name="updateDocuments" access="remote" output="false">
    
        <cfquery datasource="#mydatastore#" name="updateDocs">
            UPDATE MDL_MASTER_LIST set 
                site = <cfqueryparam cfsqltype="cf_sql_varchar" value='#FORM.docTable.site#'>,
                sections = <cfqueryparam cfsqltype="cf_sql_varchar" value='#FORM.docTable.sections#'>,
                tab = <cfqueryparam cfsqltype="cf_sql_varchar" value='#FORM.docTable.tab#'>,
                doc_number = <cfqueryparam cfsqltype="cf_sql_varchar" value='#FORM.docTable.doc_number#'>,
                description = <cfqueryparam cfsqltype="cf_sql_varchar" value='#FORM.docTable.description#'>,
                active = <cfqueryparam cfsqltype="cf_sql_varchar" value='#FORM.docTable.active#'>,
            WHERE doc_number = <cfqueryparam cfsqltype="cf_sql_varchar" value='#FORM.docTable.ARGUMENTS.original.doc_number#'>
        </cfquery>
    </cffunction>
</cfcomponent>

Ajax: This is where I am having issues with

table.MakeCellsEditable({
    "onUpdate": updateDataBaseTable,
    "inputCss":'my-input-class',
    "columns": [0,1,2,3,9],
    "allowNulls": {
        "columns": [1],
        "errorClass": 'error'
    },


function updateDataBaseTable() {
    var updateDataBase = function(doc_number){

    $.ajax({
        post: "masterMaint.cfc",
        data:$('#docTableID').serialize(),
        success: function(data) {

            alert('OK');

        }
    });
};
0 Answers
Related