Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 Community Forums
 Community Discussions (All other subjects)
 Date check for Login

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!
Before posting, make sure you have read this topic!

Screensize:
UserName:
Password:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkInsert EmailInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
   

T O P I C    R E V I E W
thermal_seeker Posted - 31 December 2010 : 07:42:48
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

Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000 Version 3.4.07