Request.Form NOT working after updating a rec.

[BobbyP57]

Hi All, I have a form and I'm updating a rec. I have POST for my method and I want it to go to page 2 after updating(Writing into the db if fine).

On page 2 I have

dim i_Status
i_Status = Request.Form("Status")

response.write(i_Status)

and I get nothing. Now if I take out the update function all works well.

Please help. I have a Due Date of 7/28/11 1500 for this. This should be something REALLY simple

Bobby

[bregent]

So if I understand correctly, you are posting a form on one page to a script on another page which updates the database, and then goes to page 2?

You are not posting to Page 2 so there is no Request.Form collection - right! You'll need to transfer the data using another method (session variable, querystring or requery the database)

[BobbyP57]

Hi bregent. Thanks for taking so time to look into this

So I have a form I want to insert it into the DB then after the insert I want it to go to page 2 to send a email -- Well this does not work

So my work around is on page 1 I have my form and I tell it to go to page 2 on submit. Now on page 2. I use request.form and transfer the data into all the form elements and submit this page into the DB and fire my email. Now I have this working only on a insert. Now I'm fighting with the update page. Same setup as above except it will not update the DB.

Did this make any sense?

Thanks

Bobby

[bregent]

>So I have a form I want to insert it into the DB then after the insert

>I  want it to go to page 2 to send a email -- Well this does not work

Yeah, no reason to go to two script pages.  Just do it all on one page - which is what I believe you are doing below.

>Now I have this working only on a insert. Now I'm fighting with the update page.

So your insert script works, but your update script does not? We would need to see the entire page code to take this further.