Dear Friends,
I want to make a secure login section to a site that I can count the hits and record the user’s last login.
My MSsql is set up with:
UserID Autonumber
UserName varchar
Password varchar
Date varchar
Hits ?
LastLogin varchar
How do I set the “hits” to an initial value of “0”?
<cfform>
<input type="hidden" name="Date" value="<cfoutput>#DateFormat(Date,'mm/dd/yyyy')#</cfoutput>">
<input type="Hidden" name="Hits" value="#IncrementValue(Hits)#">
Which is better to use for the value of “lastlogin”?
<input type="hidden" name="lastlogin" value="#DateFormat(LastLogin,'mmmm/dd/yyyy')#">
<input type="Hidden" name="LastLogin" value="#Now()#">
</cfform>
Thanks
Steve
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
- Re: Counting Login Hits recommendations >>> Steve Kahn
- Re: Counting Login Hits recommendations >>> Larry C. Lyons