ColdFusion datatable page not deleting from database
ColdFusion datatable page not deleting from database
btvbill
Posts: 11Questions: 0Answers: 0
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]
[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.