Added: November/27/2006 at 10:38pm | IP Logged

Hi All,

I have the following statement in an asp page:

Att_New = Current.Fields.Item("attempts").Value + 1

The above statement will work fine. However, what i actually need is for + 1 to be a value to be acquired from the form. The data is collected from the form with the line below:

insert_attempts = Request.Form("Attempts")

Does anyone know how to code this line to that Att_New = current database value + new value acquired from the form.

Any help is appreciated. Thank you.

Added: November/28/2006 at 5:17am | IP Logged

Hi,

Could you please explain better. Cause im not sure i got what you are talking about.

Best Regards

Firas S Assaad

Added: November/28/2006 at 2:27pm | IP Logged

Thanks for the response,

What I am trying to do is add the value submitted via the form to the value currently in the database.

For example, in the database, I have a field called attempts and the current value of this field is 10. I then have a form to update this field. If some selects 10 on the form and submits it, i want to add the both values together to that i can update the database with this new total.

Hope this explained it a little better

Added: November/28/2006 at 5:30pm | IP Logged

Got this fixed. I just added another field in the table to hold the value from the form. I was then able to use the following command

Att_New = Current.Fields.Item("attempts").Value + Current.Fields.Item("temp_att").Value

And this worked just fine. Probably not the best way to do business but it works.

Thanks all

Added: November/28/2006 at 11:32pm | IP Logged

Hi,

Just to make that i understood you 100%

If there is a field in the database that has the value of 10 and a user submits a value of 5 in order to add this value with the value in the field in the database, then after submitting that field will end up to have the value of 15 right??

if yes, then i dont think what you did in the last post works

use this instead:

Current.Fields.Item("attempts").Value = Current.Fields.Item("attempts").Value + request("THE_FIELD_NAME_IN_THE_FORM_THE_USER_WOULD_SUBMIT")

Hope this help.

If not, please let me know.

Best Regards

Firas S Assaad