Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › update query

update query

Thread began 4/03/2022 7:45 am by birdscreen398247 | Last modified 4/03/2022 11:42 am by Ray Borduin | 176 views | 3 replies |

4/03/2022 7:45 am | #1 birdscreen398247

insert query

The insert query starting at line 38 throws up a SQL syntax error and doesn't run.

Attached Files

PORC_Admin_Batch_Round2_Form.php

4/03/2022 11:14 am | #2 Ray BorduinWebAssist

This:
$rsMembers['member_name']

Should be:
$rsMembers->getColumnVal('member_name')

Did this help? Tips are appreciated...

4/03/2022 11:33 am | #3 birdscreen398247

Now I get.

Fatal error: Uncaught Error: Call to a member function getColumnVal() on array in /home/w72w9xoqmrbx/public_html/porc/PORC_Admin_Batch_Round1_Form.php:52 Stack trace: #0 {main} thrown in /home/w72w9xoqmrbx/public_html/porc/PORC_Admin_Batch_Round1_Form.php on line 52

Attached Files

PORC_Admin_Batch_Round1_Form.php

4/03/2022 11:42 am | #4 Ray BorduinWebAssist

Sorry my mistake. I didn't see the foreachloop above.

Try this. Update line 47 to:
foreach($rsMembers->Results as $rsMembersArr) {

Then update:
$rsMembers->getColumnVal("member_name")

to:
$rsMembersArr["member_name"]

If you still get an error, copy and paste the exact error message and I can try to help.

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.