updating

[mary555]

My problem is that I am displaying an entire table from an sql server table, in my asp form, using text fields. I want the user to be able to update anything in the table by simply changing a value in the text field and then pressing a button which will run sql and update the table row that was altered. I am using putting a different number at the end of each text field name so that I know which one is being changed. The problem occurs here: once the user actually changes the value, I was going to have it pass the new row values to another page and then run the sql from the 2nd page. But I think I would have to 'submit' the form so that the new values are passed, right????However, if I do that, the original values are put in the text boxes because they are being generated from result sets....any help would be appreciated

 

[DotNetGnat]

i dont understand why the old values(populated from the recordset) are getting passed when you submit the form...

when you submit the form the value of the text field will have to get passed...so when the user makes any changes the changed value is the one which get passed on to the next page when the form is submitted...

are you retrieving the value using REquest.form("mytxtfld")

please show us some code snippets...

-DNG

 

[mary555]

hmm...do you mean when I submit the form with a submit button?

 

[DotNetGnat]

yes...even if you use other means of submitting the form...the values you get should still be the updated values...

-DNG

 

[mary555]

like if i do something like form.submit(), the new values do not get passed....

 

[mary555]

im just gonna try one thing then ill let you know whats happening...

 

[mary555]

ok i think i got it! i didn't realize it was that simple as to use a submit button. i always try to make things more complicated than they are. thanks again DNG!

 

[DotNetGnat]

no problem...glad to assist...

-DNG