August's CompTIA IT Fundamentals course includes 19 hours of basic computer principle modules and prepares you for the certification exam. It's free for Premium Members, Team Accounts, and Qualified Experts!
<!--- in this query select NOTHING from table #request.RegisterTable#, and simply check if x_email exists ---> <cfquery datasource="#APPLICATION.dataSource#" name="CheckUserEmail"> SELECT 'Nothing' FROM #request.RegisterTable# WHERE x_email = <CFQUERYPARAM CFSQLTYPE="cf_sql_varchar" VALUE="#form.x_email#"> AND RegisterID <> <cfqueryparam cfsqltype="cf_sql_integer" value="#val(form.RegisterID)#"> </cfquery> <!--- if x_email exists, display error; refuse record insert ---> <cfif CheckUserEmail.recordcount GT 0> <cfthrow message="That email address is already in use. Did you already register for the NNVAWI conference? Please contact NNVAWI at email@example.com."> </cfif>
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.