> <cfquery name="check_email" datasource="#mydbname#">
>
> SELECT newsletter_id, email_address
> FROM newsletter
> </cfquery>
> <cfif 'email_address' EQ <!--- I have tried IS also --->
> #form.email_address#>
> Your email address is already in our system.
> <cfelse>
> <cfquery datasource="#mydbname#" name="newsletter">
> INSERT INTO newsletter (email_address)
> VALUES('#form.email_address#')
> </cfquery>
> You are now registered to The Newsletter.
> </cfif>
Did you forget the WHERE clause in your first query?
Michael T. Tangorre
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
