Add to exsiting value on update

Discussion in 'ASP General' started by Mangler, Oct 23, 2006.

  1. Mangler

    Mangler Guest

    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.....
     
    Mangler, Oct 23, 2006
    #1
    1. Advertising

  2. Mangler

    Mike Brind Guest

    "Mangler" <> wrote in message
    news:...
    >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
     
    Mike Brind, Oct 23, 2006
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Hartmut Schroth
    Replies:
    3
    Views:
    3,539
    Hartmut Schroth
    Dec 1, 2003
  2. joun
    Replies:
    9
    Views:
    2,278
    W.G. Ryan eMVP
    Nov 30, 2004
  3. joun
    Replies:
    5
    Views:
    2,706
  4. AAJ
    Replies:
    0
    Views:
    641
  5. Martin Honnen
    Replies:
    2
    Views:
    1,225
    Alexey Smirnov
    Nov 17, 2009
Loading...

Share This Page