Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › change value button

change value button

Thread began 2/16/2010 12:10 pm by mr hankey | Last modified 2/17/2010 5:48 pm by Dani Chankhour | 1267 views | 3 replies |

2/16/2010 12:10 pm | #1 mr hankey

change value button

hi,

I have in my db a clients table which holds a conversion column with default value "0"

i need to create a button on details page which when click changes this from 0 to 1 where 1 = a sale.

could you please advise how i would do this?

many thanks

2/16/2010 3:45 pm | #2 Dani Chankhour

You can use the DataAssist Update Server Behavior to do this, and set the trigger to use the button clicked. You will need to set a hidden field to store the your client id, because you will use that to know which record to update.

2/17/2010 12:27 pm | #3 mr hankey

thanks dani, so do i put on step 1 the key column "conversion" and value 0 then next page select "conversion" and put in value 1?

thanks again

2/17/2010 5:48 pm | #4 Dani Chankhour

No, so after you set the value of the hidden field to be your primary key column, the key column needs to be the key column of your table (the ID), which should be the unique column, and set the value to the hidden input field.

and on the next step you would select the conversion column and set the value to 1.

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.