Date check for Login
Snitz™ Forums 2000https://forum.snitz.com/forumTopic/Posts/69784?pagenum=1
04 November 2025, 18:35
Topic
thermal_seeker
Date check for Login
31 December 2010, 07:42
Date check for Login
31 December 2010, 07:42
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:
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
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:
Code:
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