Databridge V2 with MySQLi support IS Now Available!

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › conditional updating

conditional updating

Thread began 1/10/2022 8:32 am by birdscreen398247 | Last modified 1/11/2022 1:34 pm by birdscreen398247 | 299 views | 5 replies

1/11/2022 10:58 ambirdscreen398247

When I run that code, I get "there is an error in your SQL"

I have since changed the code to"

$UpdateQuery->bindColumn("batch_date", "t", "".($rsDecisions->getColumnVal("batch_date")?"":$_POST["batch_date"]) ."", "WA_IGNORE");

As the field to check is $rsDecisions->getColumnVal("batch_date"") rather than the rsBatch_dates one.

Now when I submit, it just goes to a blank page (without updating).

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.