I was just checking my newsletter signup form before i went to bed and the
damn thing isnt working. It always says that the email address is already in
the system...but the db is empty. It was fine when i first made it so I dont
know what i did. Here is the code:
<cfquery name="check_email" datasource="#mydbname#">
SELECT *
FROM newsletter
where lcase(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. If you feel this is in error
please contact <a href="" PROTECTED]">the support
team</a>.
<cfelse>
<cfquery datasource="#mydbname#" name="newsletter">
INSERT INTO newsletter (email_address)
VALUES('#form.email_address#')
</cfquery>
You are now registered to The Applewood Community Newsletter. You should
recieve a confimation in an e-mail shortly. You will redirected to the home
page shortly.
Whats wrong with it?
Thanks Phil
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings] [Donations and Support]
