469,921 Members | 2,213 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,921 developers. It's quick & easy.

help setting up log in and query

I have a form with 2 text boxes one for username another for pwd and an option box to select a module ) retriving data from a database called ict ,this should display the results when username and pwd are verfied according to the selected module (NW,SW or HW ) so how codes should they look like ? ...especially the querry .

Thanks
by oliver R
Oct 16 '07 #1
1 1016
jhardman
3,406 Expert 2GB
I have a form with 2 text boxes one for username another for pwd and an option box to select a module ) retriving data from a database called ict ,this should display the results when username and pwd are verfied according to the selected module (NW,SW or HW ) so how codes should they look like ? ...especially the querry .

Thanks
by oliver R
please explain the database setup: what are the names of the tables and fields within the db?

First figure out the log in. If log in is incorrect, go back to the log in, otherwise open the db with something like this:
Expand|Select|Wrap|Line Numbers
  1.  query = "SELECT * FROM tabelName WHERE module = '" & request.form("modSelect") & "'"
Oct 17 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by david.good | last post: by
reply views Thread by David | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.