On Wed, 6 Oct 2004 16:19:28 -0400, Howie Hamlin <[EMAIL PROTECTED]> wrote:
> My server is case-insenstive :)
>
> 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]
