I have a question about this example:
http://net.tutsplus.com/tutorials/javascript-ajax/submit-a-form-without-page-refresh-using-jquery/
I am using coldfusion and jquery to have someone fill out the form, validate the name and email address and then insert it into my database. However, I would also like to check the database to make sure that I don't get duplicate email addresses. How would I go about doing that?
I am using the same code as shown on that website. The only difference is that I don't have a return phone field. I only have name and email address.
Currently I am trying to use a simple query to tell if the email address exists:
<cfquery name="check" datasource="lbdb_">
Select * from tbl_member
where member_email = '#url.email#'
</cfquery>
<cfif check.recordCount eq 0>
query to insert into database and a message to the user
</cfif>
What would I have to do to get your 2nd option to work?
Thanks for the help.