Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Update record

Update record

Thread began 10/28/2021 10:47 am by birdscreen398247 | Last modified 10/29/2021 10:31 am by Ray Borduin | 205 views | 3 replies |

10/28/2021 10:47 am | #1 birdscreen398247

Update record

See the attached file.

When I click on the checkbox and then Submit, it is not updating the table.

Attached Files

PORC_Admin_Batch_List.php

10/29/2021 9:26 am | #2 Ray BorduinWebAssist

I think you attached the wrong file... there is no checkbox or submit button on the page.

Did this help? Tips are appreciated...

10/29/2021 9:44 am | #3 birdscreen398247

Here is the correct file.

Attached Files

PORC_Admin_Batch_Records_List.php

10/29/2021 10:31 am | #4 Ray BorduinWebAssist

The code looks like it has an issue... you have:

php:

$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:

php:

$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"))  ."");

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

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.