Regards,
Howie
----- Original Message -----
From: Greg Morphis
To: CF-Talk
Sent: Wednesday, October 06, 2004 4:09 PM
Subject: Re: Check emails not working
Yeah do what Howie said however use <cfqueryparam and check for case
<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>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
