Page Load Using Result From Previous Page

[Mike Bussiere]

Using Windows platform with FP2K and MSSQL2005



I would like a visitor to enter a UN and PW on page1 hit the submit button
and then be directed to page2.

When page 2 loads it uses the UN and PW entered from page1.



The question is this:

How do I get page2 to load, query the db and fill in the FP2K database
results.



The page2 query would go something like this:

a.) get un & pw from page1

b.) query db with un & pw

c.) if un & pw found in db then load results into page2 FP2K db
results

d.) if un & pw are not found in db then reload page1 with message (un
or pw incorrect, please try again)



Thank you in advance

Mike

 

[David Berry]

You can use the FrontPage Database Wizard (see
http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp for tips) or
straight ASP Code. See http://www.kamath.com/tutorials/tut003_auth.asp for
an example.

On the second page you can get the Username and Password from the previous
page by either requesting the values that were in the form or putting those
values into a Session variable that can be used wherever on the site. Ex:

From the form:

strUserName = Request.Form("UserName")
strPassword = Request.Form("Password")

From a Session variable (you'll need to create this after the login on page
1

strUserName = Session("UserName")
strPassword = Session("Password")

 

[Mike Bussiere]

Thanks David,

Got it working fine now.

Regards
Mike
======================================