The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
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
No replies