<cfquery name="check_email" datasource="#mydbname#">
SELECT email_address
FROM newsletter
where lower(email_address)=<cfqueryparam cfsqltype="cf_sql_varchar"
value="#lcase(form.email_address)#">
</cfquery>
<cfif check_email.recordcount neq 0>
Your email address is already in our system.
<cfelse>
On Wed, 6 Oct 2004 16:05:33 -0400, Tangorre, Michael
<[EMAIL PROTECTED]> wrote:
> > From: Phillip Perry [mailto:[EMAIL PROTECTED]
> > <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]
