Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Date check for Login
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

thermal_seeker
Junior Member

United Kingdom
430 Posts

Posted - 31 December 2010 :  07:42:48  Show Profile  Reply with Quote
I can't seem to figure this out...
Carefree sorted out the renewal date problem for the forum and it is working extremely well, Thanks Carefree

I also have a login page for another part of the site (.net 3.5)that uses the UN/PW from the forum's database and that works well.
To this login I need to add the date check to see if the membership is current.
This is the line I think I need to add to:
Dim sqlStmt As String = "select count(*) from FORUM_MEMBERS where M_NAME='" & UsernameTextBox.Text & "' and M_PASSWORD='" & pswd & "'"


but I'm at a loss as what to add. I'm presuming it must be an sql statement to see if the date of login is lesser than the one in the database (MS SQL 2005)??
Date format in database is yyyymmdd

Any help appreciated

Happy New Year to you all

Dave

No good at coding, but I can plough a field !!
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.12 seconds. Powered By: Snitz Forums 2000 Version 3.4.07