Multiple record update not updating database

3/19/2020 11:39 am | #1 Jay Core Global Media

I have recently purchased the new databridge am trying update a settings form on a settings page. Am not sure if I have set it up correctly, form submits however does not update.

3/19/2020 1:48 pm | #2 Ray BorduinWebAssist

It looks like you have a dynamically named index field:

php:

<input id="<?php echo($SiteSettings->getColumnVal("SettingsID")); ?>" name="<?php echo($SiteSettings->getColumnVal("SettingsName")); ?>" type="<?php echo($SiteSettings->getColumnVal("SettingsType")); ?>" value="<?php echo($WAGlobals->getColumnVal("SettingsValue")); ?>" class="form-control control-group" tabindex="<?php echo($SiteSettings->getColumnVal("SettingsWeight")); ?>" title="Please enter a value." required="true">

It shouldn't be... it should just be:

php:

<input id="setting_<?php echo($wa_startindex); ?>" name="setting_<?php echo($wa_startindex); ?>" type="text" value="<?php echo($WAGlobals->getColumnVal("SettingsValue")); ?>" class="form-control control-group" title="Please enter a value." required="true">

Then you don't have a binding set to update that column. You would need to update the code above from:

php:

$UpdateQuery->Table = $MultipleUpdateTable;

    $UpdateQuery->addFilter($MultipleUpdateIndexColumn, "=", $MultipleUpdateIndexColumnType, $_POST[$MultipleUpdateIdentifier."_".$MultipleUpdateCount]);

to:

php:

$UpdateQuery->Table = $MultipleUpdateTable;

    $UpdateQuery->bindColumn("SettingsValue", "s", "".((isset($_POST["setting"."_".$MultipleUpdateCount]))?$_POST["setting"."_".$MultipleUpdateCount]:"")  ."", "WA_BLANK");

    $UpdateQuery->addFilter($MultipleUpdateIndexColumn, "=", $MultipleUpdateIndexColumnType, $_POST[$MultipleUpdateIdentifier."_".$MultipleUpdateCount]);

Did this help? Tips are appreciated...

3/19/2020 4:11 pm | #4 Ray BorduinWebAssist

This looks like it would work to me. I'd have to debug it live. Can I get a url with login information to test and FTP access? Otherwise I could help you debug it in a screen sharing session.

Did this help? Tips are appreciated...

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

Multiple record update not updating database

3/19/2020 11:39 am | #1 Jay Core Global Media