Hope that is you searching......
Code:<cfset CurrentPage=GetFileFromPath(GetTemplatePath())> <cfparam name="FORM.UserID" default="1"> <cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "register"> <cfquery datasource="walyerMembers"> INSERT INTO tblWalyerMembers (UserID, Password, Date, Email) VALUES ( [COLOR=green] <cfif IsDefined("FORM.userid") AND #FORM.userid# NEQ ""> <cfquery name="Recordset1" datasource="walyerMembers"> SELECT UserID FROM tblWalyerMembers WHERE UserID = '#FORM.UserID#' <cfoutput> <cfinclude template="register.cfm" /> <div align="center" class="style3">*Your User Name is already taken by another User.*</div> </cfoutput> </cfquery> <cfelse> '#FORM.userid#' </cfif>[/COLOR] , <cfif IsDefined("FORM.password") AND #FORM.password# NEQ ""> '#FORM.password#' <cfelse> NULL </cfif> , <cfif IsDefined("FORM.email") AND #FORM.email# NEQ ""> '#FORM.email#' <cfelse> NULL </cfif> )</cfquery> <cflocation url="registerComplete.cfm"> </cfif>



LinkBack URL
About LinkBacks




Bookmarks