Update record
See the attached file.
When I click on the checkbox and then Submit, it is not updating the table.
See the attached file.
When I click on the checkbox and then Submit, it is not updating the table.
I think you attached the wrong file... there is no checkbox or submit button on the page.
The code looks like it has an issue... you have:
$UpdateQuery->bindColumn("Batch_Date", "t", "".($rsBatchRecords->getColumnVal("batch_date")) ."", "WA_DEFAULT");
$UpdateQuery->bindColumn("Completed", "c", "".((isset($_POST["Completed"]))?$_POST["Completed"]:"") ."", "WA_DEFAULT");
$UpdateQuery->addFilter("Batch_Date", "=", "t", "".($rsBatchRecords->getColumnVal("Batch_date")) ."");
The first thing I see is that you have "batch_date" and "Batch_date"... only one of these is correct, or maybe neither since in the query you have "Batch_Date"
I think you want:
$UpdateQuery->bindColumn("Batch_Date", "t", "", "WA_TIMESTAMP");
$UpdateQuery->bindColumn("Completed", "c", "".((isset($_POST["Completed"]))?$_POST["Completed"]:"") ."", "WA_DEFAULT");
$UpdateQuery->addFilter("Batch_Date", "=", "t", "".($rsBatchRecords->getColumnVal("Batch_Date")) ."");
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.