Can't get form value from first page to go the next after posting 2

[MustangManny]

The first page is a form.
I have used the server behavior INSERT RECORD
on that dialog box there is:
After inserting GO TO: where you can choose a page to direct it to.
I would like to add a query string to it like
thispage.asp?number= [The value of a form filed here ]
I used VB script so that it would look like
thispage.asp?number= <%=(Recordset1.Fields.Item(&quot;event_code&quot.Value)%> And it would not work.

I just want the next page to be able to pull up the info that was just entered into the database.

Thanks in advance.

Manny

 

[ConstantSTATEofFLUX]

you don't add the ?field=<%=variable%> at this point

Set your form action to get and on the next page, do your sql requesting what you're passing in the url

[tt]^{Nothing in life} _{is to be feared.} ^{It is only to be understood}

 

[Cheech]

wont work

the forms data is &quot;lost&quot; after inserting.

Not a clean method but if you have an autonumber field in your db then use a select max autoid statement to grab the last entered record. If this is a busy site then this will probably cause problems.

Cheech

[Peace][Pipe]
If you don't stand up for something, you'll fall down. Toke it Easy.
Howard Marks.

 

[MustangManny]

Thank you to both!

Please clarify.
Cheech, you're saying my approach won't work.
But will ConstantSTATEofFLUX's solution work?

 

[ConstantSTATEofFLUX]

your method won't work


To keep it simple, you should have 3 pages (to keep it simple I said)

Page1 = Form

Page2 = The verification page which populates the page with all <%=Request.Form(&quot;Variables_Fields&quot%> then sends the information to page3

Page3 = The processing page which takes the form's variable data, then on the same page you can place your logic to actually email upon submitting the form then insert to your database



[tt]^{Nothing in life} _{is to be feared.} ^{It is only to be understood}

 

[MustangManny]

ConstantSTATEofFLUX in your example, would Page1 = Form be POST or GET? GET I would assume?

Thanks again.

 

[ConstantSTATEofFLUX]

get

[tt]^{Nothing in life} _{is to be feared.} ^{It is only to be understood}

 

[ConstantSTATEofFLUX]

sorry MustangManny, change the FORM1 TO POST

I misread the question



POST
POST
POST
POST
POST
POST
POST
POST
POST
POST
POST
POST
POST
POST
POST
POST


Just to be sure

[tt]^{Nothing in life} _{is to be feared.} ^{It is only to be understood}