Thanks Olga...with a little more tweaking and your code everything works!
>-----Original Message-----
>From: Olla Ts [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, June 27, 2000 8:15 PM
>To: [EMAIL PROTECTED]
>Subject: Re: login counter
>
>
><cfif IsDefined("form.Email") AND Len(Trim(Form.Email))>
> <cfset Variables.Email = Trim(Form.Email)>
> <cfquery name="Getcb" datasource="freecb">
> SELECT email, Login
> FROM freecb
> WHERE email = '#Variables.Email#'
> </cfquery>
> <cfif Getcb.RecordCount GT 0>
> <cfset Variables.LoginCount = Getcb.Login + 1>
> <cfquery name="UpdateCount" datasource="freecb">
> Update freecb
> SET Login = #Variables.LoginCount#
> </cfquery>
> </cfif>
><cfelse>
> <cflocation url="http://www.yahoo.com" addtoken="No"> <!---
>;) --->
></cfif>
>
>----- Original Message -----
>From: "Robert Orlini" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Tuesday, June 27, 2000 10:25 AM
>Subject: login counter
>
>
>| 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/c
>f_talk or send a message to [EMAIL PROTECTED]
>with 'unsubscribe' in the body.
>|
>
>-------------------------------------------------------------------
>-----------
>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.
------------------------------------------------------------------------------
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.