Wednesday, October 06, 2004 4:09 PM
> Subject: Re: Check emails not working
>
> Yeah do what Howie said however use
>
>
>
> SELECT email_address
> FROM newsletter
> where lower(email_address)=
> value="#lcase(form.email_address)#">
>
>
>
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
SELECT email_address
FROM newsletter
where
Thanks Howie that worked. I just thought I could do it in a cfif tag.
-Original Message-
From: Howie Hamlin [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 4:00 PM
To: CF-Talk
Subject: Re: Check emails not working
Try:
SELECT email_address
FROM newsletter
No I never put one in.
-Original Message-
From: Tangorre, Michael [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 4:06 PM
To: CF-Talk
Subject: RE: Check emails not working
Did you forget the WHERE clause in your first query?
Michael T. Tangorre
[Todays Threads
Yeah do what Howie said however use
SELECT email_address
FROM newsletter
where lower(email_address)=
value="#lcase(form.email_address)#">
Your email address is already in our system.
On Wed, 6 Oct 2004 16:05:33 -0400, Tangorre, Michael
<[EMAIL PROTECTED]> wrote:
> > From: Phillip Perry [m
#form.email_address#>
you're saying... if their email equals "email_address", and thats not
a valid email address..
try
that way
[EMAIL PROTECTED] and [EMAIL PROTECTED] dont sign up.
On Wed, 6 Oct 2004 15:52:50 -0400, Phillip Perry
<[EMAIL PROTECTED]> wrote:
> The situation I have to deal wi
> From: Phillip Perry [mailto:[EMAIL PROTECTED]
>
>
> SELECT newsletter_id, email_address
> FROM newsletter
>
>
> #form.email_address#>
> Your email address is already in our system.
>
>
> INSERT INTO newsletter (email_address)
> VALUES('#form.email_address#')
>
> You are now registered to
PM
Subject: Check emails not working
The situation I have to deal with now is this...
A form gets filled out with just an email address. When the submit button is
clicked the action page for putting the address in the DB is brought up.
This page is supposed to check to see if the sa
The situation I have to deal with now is this...
A form gets filled out with just an email address. When the submit button is
clicked the action page for putting the address in the DB is brought up.
This page is supposed to check to see if the same email address is already
in the system, and if it
9 matches
Mail list logo
