Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

database results based on user login

Status
Not open for further replies.

deanbri75

Technical User
Jan 6, 2004
26
US
I have a form that I want to display results based on the user who authenticated. For instance, SELECT * FROM TABLE WHERE USER = ::username::

I set the permissions for the site to give "DOMAIN/domain users" browse rights so they have to login. Is there a way to capture the login info and use it as the variable for the database results?

I know you can do it using a form & POST, but I want to make sure that the variable is from the person authenticating to the page. This would prevent someone from logging in then letting their buddy put their username in the username form field. (I've actually had this happen.)

I don't know much about our frontpage server, but I know it's running fronpage extensions. Everything I've done so far has been simple and used the Database Results Wizard.

thanks,
b
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top