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]
