Microsoft Access Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseMicrosoft Access Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old January 21st, 2004, 11:40 AM
kristie ann kristie ann is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Posts: 24 kristie ann User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Username & password problem

Hey,

I am creating a login system where a user can register only if the username entered matches a list of usernames in the database. They are then required to enter a password and retype a password to register. The main problem Im having is making sure that the username entered matches that in the database. Also I need to make sure that the password field in the database is empty, if not then they are an existing user.... Please if anyone has some code that would help me with my problem that would be great...Thanks

Reply With Quote
  #2  
Old January 21st, 2004, 12:04 PM
Memnoch's Avatar
Memnoch Memnoch is offline
Unholy Moderator
ASP Free God 14th Plane (11500 - 11999 posts)
 
Join Date: Oct 2003
Location: In hell, where did you think?
Posts: 11,764 Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level)Memnoch User rank is Lieutenant Colonel (40000 - 50000 Reputation Level) 
Time spent in forums: 3 Weeks 5 Days 6 h 8 m 20 sec
Reputation Power: 452
To match a username in database. (Assuming you are doing this in ASP)
Code:
'Get the Username entered by the user
Username = Request.Form("txtUsername")

'Create you objects
Set Conn = Server.CreateObject("ADODB.Connection")
Set results = Server.CreateObject("ADODB.Recordset")

'Connect to the database
Conn.Open "Your ConnectionString"
'Assuming your connectionstring looks something like this
"Driver={Microsoft Access Driver (*.mdb)};Dbq=C:\mydatabase.mdb;Uid=Admin;Pwd=;"

'The sql statement that checks the database
sql = "SELECT * FROM tableName WHERE UserNameField = '" & Username & "'"

'Execute the sql statement
results = Conn.Execute(sql)

If(results.eof) Then
   No record matches the Username
End If

Do until results.eof
   'There were records in the database that match the username
   'Check if password field is empty
   If(results("PasswordField") = "") Then
      'Password field is empty
   End If
   results.movenext
Loop

'Close the database connection
Conn.Close

'Set your objects to nothing
Set results = nothing
Set Conn = nothing

Reply With Quote
  #3  
Old January 21st, 2004, 03:20 PM
kristie ann kristie ann is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Jan 2004
Posts: 24 kristie ann User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Thanks Memnoch,

The majority of this code is working.
However I am having problems when I try to assign a password that the particular user has entered.

Do until results.eof
'There were records in the database that match the username
'Check if password field is empty
If(results("PasswordField") = "") Then
'Password field is empty
results("PasswordField")=Password
results.Update
End If
results.movenext
Loop

I have included the code highlighted in red, but the password is not saving to the database. I just cant figure out the problem. I would really appreciate help with this...
Thank You

Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseMicrosoft Access Help > Username & password problem


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 4 hosted by Hostway
Stay green...Green IT