How do I pass information tied to dropdown Field

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

This is in FrontPage 2003

I have a form set up that the user selects a unique ID from a dropdown based
on a database.

Using this same database ID, I want the Confirmation page to show this ID as
well as additional fields from the database that are tied to this ID.

This ID and other information being input in the initial form are being sent
to a second database.

An example the user is inputting First Name - Last name - selecting a class
ID form a dropdown list and clicking submit.

When the confirmation page comes up, I want the user to see the class
information as well as his/her name.

I am really stuck.

Dave
 
Some more info!

In my code I have only one value listed and that is for the CID. How do I
pass a value for CLASS which is A+ and the DATE which is June 6th.

Or how do I display the database results tied to the CID? Either way would
give me what I want.

Thanks

Dave

Skydolphin said:
There are several different ways to do this. Assuming you are using an
ASP page the easiest way is this. In your form tag make sure you have the
action=address of the confirmation page and method=post. Then in the ASP
script in the confirmation page you can set variables equal to the posted
values from the form page. Something like:
 
This makes sense, but here is the catch unless I am missing your point.

To make this simple for my poor brain.

The student inputs his/her NAME. Then uses the drop down to choose A+ on
June 6th which is being fed from a database. Tied to this record is CID 7.

On the confirmation page I get "7", and the student NAME, but not A+ on June
6th.

The CID is being fed, but not the A+ or June 6th.

I tried a Results Wizard and I can show all the classes, but if I try to tie
the results to the CID, I get the yellow error the wizard generates.
Am I missing the point?

Thanks for writing!!!

Dave

Skydolphin said:
There are several different ways to do this. Assuming you are using an
ASP page the easiest way is this. In your form tag make sure you have the
action=address of the confirmation page and method=post. Then in the ASP
script in the confirmation page you can set variables equal to the posted
values from the form page. Something like:
 
Can you send me a copy of your code so I can see what you are doing? You can change the names of the DB and stuff for this purpose

Rhonda
 
Do you want the entire asp pages or cut and paste the code?

Thanks

Dave


Skydolphin said:
Can you send me a copy of your code so I can see what you are doing? You
can change the names of the DB and stuff for this purpose.
 
This is one place that I think another value needs to be added.

<!--webbot bot="DatabaseRegionStart" endspan i-CheckSum="47620" --><select
NAME="ClassID" SIZE="1">

<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn1.inc"
startspan --><!--#include file="_fpclass/fpdbrgn1.inc"-->

<!--webbot bot="AspInclude" endspan i-CheckSum="5346" -->

<option
VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"><%=FP_FieldHTML(fp_rs,"Class")%>&nbsp;
&nbsp;&nbsp;<%=FP_FieldHTML(fp_rs,"Date")%>

</option>

Skydolphin said:
Can you send me a copy of your code so I can see what you are doing? You
can change the names of the DB and stuff for this purpose.
 
Back
Top