Re: Check emails not working

2004-10-06 Thread Greg Morphis
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)#"> >   > >  

Re: Check emails not working

2004-10-06 Thread Howie Hamlin
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

RE: Check emails not working

2004-10-06 Thread Phillip Perry
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

RE: Check emails not working

2004-10-06 Thread Phillip Perry
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

Re: Check emails not working

2004-10-06 Thread Greg Morphis
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

Re: Check emails not working

2004-10-06 Thread Greg Morphis
#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

RE: Check emails not working

2004-10-06 Thread Tangorre, Michael
> 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

Re: Check emails not working

2004-10-06 Thread Howie Hamlin
Try: SELECT email_address FROM newsletter where email_address='#form.email_address#' Your email address is already in our system. ... HTH, -- Howie Hamlin - inFusion Project Manager On-Line Data Solutions, Inc. - www.CoolFusion.com inFusion Mail Server (iMS) - The Award-winning, Intellig