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');
}
});
};