close ad
Databridge V2 with MySQLi support IS Now Available!
open ad
View Menu

Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

rating

How do I update a column that has the same ID as one of the form fields?

Thread began 3/06/2020 8:12 am by Jonas | Last modified 3/10/2020 3:45 pm by Ray Borduin | 222 views | 21 replies |

Jonas

How do I update a column that has the same ID as one of the form fields?

I want to update a column in a table that has the same ID as one of the form fields - with the value from another form field. How should I think here?

Sign in to reply to this post

Ray BorduinWebAssist

Apply the update server behavior and set the lookup column from the one form fields and bind the value from the other.

Sign in to reply to this post
Did this help? Tips are appreciated...

Jonas

Okay, done!
Now the value is written in the column. But I want to add the "++" value to the existing value in the column.
How?

Sign in to reply to this post

Ray BorduinWebAssist

I'm afraid I don't understand exactly what you are trying to do. Maybe give an example of what the value would be before and after.

Sign in to reply to this post
Did this help? Tips are appreciated...

Jonas

Sure. If the existing value in the column is 20 then this should be added with the value from the form field. For example, 4 + 20 = 24.

Sign in to reply to this post

Ray BorduinWebAssist

You could add the values with php in a hidden form element, or use the "Execute SQL" server behavior to manually write a SQL statement that does that like:

UPDATE tablename SET column = column+4 WHERE IDColumn = value

Sign in to reply to this post
Did this help? Tips are appreciated...

Jonas

So it is not possible to work with calculation when adding or updating a column?

Sign in to reply to this post

Ray BorduinWebAssist

You could do it in the bindings panel of the update as well. It is very possible. There are at least three ways to do it. I don't know the specifics of your application so I can't comment on which one if any is preferable.

What is your current binding in the update panel? You can likely just put +4 after it to add four to the value you are currently setting it to.

Sign in to reply to this post
Did this help? Tips are appreciated...

Jonas

Late update:
I've tried to write + in the binding panel as you said, but it doesn't help. It still only inserts the value from the column, and does not add it.
Here is the updated code:
$UpdateQuery->bindColumn("ProvningPlatserBokade", "i", "+".($WADABokning_update->getColumnVal("BokningAntal")) ."", "WA_DEFAULT");

Earlier:
The idea is that admin should be able to see how many places are booked for the specific activity. Each time a booking is made, the number of seats is added to the column associated with that activity.

The number 4 was just an example. Actually, it's a number that comes from another column in another table. So different from time to time. Here is the code from update server behavior:
<?php
if (isset($_POST["Update"]) || isset($_POST["Update_x"])) {
$UpdateQuery = new WA_MySQLi_Query($AboutBeer);
$UpdateQuery->Action = "update";
$UpdateQuery->Table = "Provning";
$UpdateQuery->bindColumn("ProvningPlatserBokade", "i", "".($WADABokning_update->getColumnVal("BokningAntal")) ."", "WA_DEFAULT");
$UpdateQuery->addFilter("ProvningID", "=", "i", "".($WADABokning_update->getColumnVal("ProvningID")) ."");
$UpdateQuery->execute();
$UpdateGoTo = "";
if (function_exists("rel2abs")) $UpdateGoTo = $UpdateGoTo?rel2abs($UpdateGoTo,dirname(__FILE__)):"";
$UpdateQuery->redirect($UpdateGoTo);
}
?>

Sign in to reply to this post

Ray BorduinWebAssist

$UpdateQuery->bindColumn("ProvningPlatserBokade", "i", "".($WADABokning_update->getColumnVal("BokningAntal")+1) ."", "WA_DEFAULT");

Sign in to reply to this post
Did this help? Tips are appreciated...
loading

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.

Want your website pre-built and hosted?

Close Windowclose

Rate your experience or provide feedback on this page

Account or customer service questions?
Please user our contact form.

Need technical support?
Please visit support to ask a question

Content

rating

Layout

rating

Ease of use

rating

security code refresh image

We do not respond to comments submitted from this page directly, but we do read and analyze any feedback and will use it to help make your experience better in the future.

Close Windowclose

We were unable to retrieve the attached file

Close Windowclose

Attach and remove files

add attachmentAdd attachment
Close Windowclose

Enter the URL you would like to link to in your post

Close Windowclose

This is how you use right click RTF editing

Enable right click RTF editing option allows you to add html markup into your tutorial such as images, bulleted lists, files and more...

-- click to close --

Uploading file...