ASP - Add to exsiting value on update

Author

Add to exsiting value on update

Mangler

2006-10-30, 6:58 pm

I need a quick suggestion on the best way to accomplish the below:

A user can update a record in the db on the front end so....

if this is the first entry they input the value and submit it....

if the exsisting value needs to be updated because more came in, I want
the update to add to the exsisting value automatically on the front end
when the form is submitted ( dont trust the users math skills )

any help/suggestions are appreciated.....

Mike Brind

2006-10-30, 6:58 pm

"Mangler" <dwaldman@directwireless.com> wrote in message
news:1161616565.239282.307410@f16g2000cwb.googlegroups.com...
>I need a quick suggestion on the best way to accomplish the below:
>
> A user can update a record in the db on the front end so....
>
> if this is the first entry they input the value and submit it....
>
> if the exsisting value needs to be updated because more came in, I want
> the update to add to the exsisting value automatically on the front end
> when the form is submitted ( dont trust the users math skills )
>
> any help/suggestions are appreciated.....
>

Update Table Set field1 = (field1 + increment)

--
Mike Brind

Sponsored Links