Hello,

I am creating a browser based IT Service Request System for our in-house users.
I have created a login page (ASP) that authenticates the user from a SQL database (employee table).

How can I grab data from the employee table from the login page and use it to pre-fill some of the fields on the IT Request form?
How should I be doing this, do I use session variables, request variable... or am I just totally in the dark?

You dont have to be real specific, I just want to know if I am on the right track.

Thanks in advance!

use sessions

Regards,
Dave

[DWMX 2004]|[FlashMX 2004 Pro]|[SQL]|[Access2000]|[ASP/VBScript]|[XP-Pro]

yep, query your employee table by MM_Username which is passed by login script then show whatever you desire.....<img src=../images/dmxzone/forum/icon_smile.gif border=0 align=middle>

Thanks!
I will give it a shot and add to this topic if I have further questions.

Thanks again.

That worked... thanks!

What about the current date? How do I enter the current date on a form? Do I use the server date, if so what is the server variable for current date?

Thank you once again.