Hello,
I'm trying to create a counter for each time a user submits their email
address to login to our service via an html page. They would enter their
email address where it would get verified and then a "1" would be added to
their login column. This would keep track of how many times they logged in.
The code is below, but is not too accurate. Is there an easier way?
<cfquery name="Getcb" datasource="freecb">
SELECT * FROM freecb
Where email = email
<CFIF #email# IS NOT "">
And email Like '#FORM.email#'
</CFIF>
</cfquery>
<cfquery name="Getcb" datasource="freecb">
Update freecb
Set Login = Login + 1
Where email = '#FORM.email#'
</cfquery>
Thanks.
Robert O.
Web Admin
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
