FP 2002 Query MSA 2002 DB

[bluzegtr]

FrontPage 2002, Access 2002

I am using an example from

http://www.spiderwebwoman.com/tutorials/doubledropdown.htm

I created and ASP (search1.asp)
I created a form and populated one drop down list with a DB Query. Ex:
SELECT DISTINCT [TTR Data].State
FROM [TTR Data];

The action of the form is set to send the results to search2.asp

On the second page I display results. I inserted DB results from the table [TTR Data] selecting only the fields I want in the results. I get the correct fields returned but all of the data from all of the states is returned. It is as if the second page never got the results from search1.asp so it just displays everything.

I am running Server 2000 and have this in a public folder to you can actually go to my IP address and see it. My point is that I can get to it from outside and never get any errors so I know that the FP 2002 Extensions are installed an working.

Once I can get this part to work I will try doing the double drop down but first things first.

Don