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/tipsan...ndtricks12.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.

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

Chris Plant wrote:
> 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/tipsan...ndtricks12.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.
>
>