How do I use a Formfield value from a previous page, in a database query on another page?

C

Chris Plant

Hi, I've followed the instructions on the link below to allow password entry
and verification against a list of users in a database.

http://www.frontpageworld.com/tipsandtricks/tipsandtricks12.htm

Everything works well. It prompts me to login, but what I want to do next,
is use the username entered on the previous screen, in a database results
query.

something like ....

WHERE [managercode] = "username entered on previous screen"

but I just can't get the syntax correct, or even know if it's possible.

Can anyone help please? Thanks in advance, Chris.
 
M

MikeR

Chris -
It'll depend on what you've done so far. What is the action that happens when you click
submit? Does it write to a database, or go to another page? If it goes to another (asp)
page then
SQuery = "WHERE [managercode] = " & <%=Request.Form("Whateveryourtextboxnameis")%>
MikeR
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I use a Formfield value in a database query on another page? 0
How do I embed a google map in a web page using Front Page? 4
Passing the results of a query(variable) to a third asp page and using it in another query 3
Using a hidden field in a custom query. 0
Word How do I insert a conditional page break during a word merge? 1
posting results from a database query on web page 1
How to create a clickable link on a data results page from an access database 1
How do I make a text box display a value from the previous record 2

Top