ColdFusion datatable page not deleting from database

ColdFusion datatable page not deleting from database

btvbillbtvbill Posts: 11Questions: 0Answers: 0
edited December 2011 in DataTables 1.8
I have managed to populate a server side datatable with ColdFusion but I'm having trouble deleting a record. It deletes on the client but not from the database so it comes back upon refreshing the page. Here is most of the code for the page (I left out the stuff at the top to save space):
[code]
<!--- Get all records in database table --->

SELECT engine, browser, platform, version, grade
FROM #sTableName#
ORDER by id ASC


<!--- Place all of the above into a datatable --->
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">



Editable DataTable ColdFusion Example - Adding new record

@import "media/css/demo_page.css";
@import "media/css/demo_table.css";
@import "media/css/themes/base/jquery-ui.css";
@import "media/css/themes/smoothness/jquery-ui-1.7.2.custom.css";








$(document).ready( function () {
var oTable = $('#example').dataTable().makeEditable({
sUpdateURL: "UpdateData.cfm",
sAddURL: "AddData.cfm",
sDeleteURL: "DeleteData1.cfm"
});

} );





Editable DataTable ColdFusion example
<!-- Start box for adding new record -->

Rendering engine





Browser





Platform(s)





Engine version



1
1.7
1.8



CSS grade



First


Second


Third


<!-- End box for adding new record -->





Rendering engine
Browser
Platform(s)
Engine version
CSS grade




Rendering engine
Browser
Platform(s)
Engine version
CSS grade





#engine#
#browser#
#platform#
#version#
#grade#










[/code]

And here is what I have it DeleteData1.cfm:
[code]

You did not define a record to delete




DELETE FROM tabletest
WHERE (id = #id#)

[/code]
This discussion has been closed.