I’ve created a register form that includes some Dreamweaver generated code and code of my own. What I did was within the main query that handles the insert of the userID I added another query within the <cfif> to see if the userID already exists. The problem is that when I test the form it goes no where, just keeps thinking.
The dark orange is where i believe I have the problem.
Here is the my query code;
<cfparam name="FORM.UserID" default="1">
<cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "register">
INSERT INTO tblWalyerMembers (UserID, Password, Date, Email)
<cfif IsDefined("FORM.userid") AND #FORM.userid# NEQ "">
<cfquery name="Recordset1" datasource="walyerMembers">
WHERE UserID = '#FORM.UserID#'
<cfinclude template="register.cfm" />
<div align="center" class="style3">*Your User Name is already taken by another User.*</div>
<cfif IsDefined("FORM.password") AND #FORM.password# NEQ "">
<cfif IsDefined("FORM.email") AND #FORM.email# NEQ "">
Any ideas will be great.