There anyone that can assist me in this? > I've been trying for some time trying to get various examples that > I've found online how to do this, but none seem to do any checking > after I leave the input field that contains the username to be checked. > I'll first post the link to my work in progress and then post my code > to my .cfm and .cfc pages. > > Link: http://students.uwf.edu/dsl13/mva/new_user.cfm > > > new_user.cfm > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> > <html xmlns="http://www.w3.org/1999/xhtml";> > <head> > <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> > <title>New User Registration</title> > <link href="main.css" rel="stylesheet" type="text/css" media="screen, > handheld" /> > </head> > > <body> > <div align="center"> > <img class="vetimg" src="images/Color_Logo_Original.jpg" /> <br /> > <div class="title">Mobile Veterinary Assistant</div> > <script type="text/javascript" src="http://jqueryjs.googlecode. > com/files/jquery-1.3.2.min.js"></script> > <script type="text/javascript"> > chkUsernameUnique = function(theUsername){ > $.getJSON("assets/cfc/userchecker.cfc", { > method: &<a class="_hootified" a="" href="#" #039"="" > onclick="javascript:var e = document.createEvent("CustomEvent"); e. > initCustomEvent("hootletEvent", true, true, {type: "hash", value: > "#039"}); document.body.dispatchEvent(e); return > false;">#039</a>;chkUsername&<a class="_hootified" a="" href="#" > #039"="" onclick="javascript:var e = document. > createEvent("CustomEvent"); e.initCustomEvent("hootletEvent", true, > true, {type: "hash", value: "#039"}); document.body.dispatchEvent(e); > return false;">#039</a>;, > Username: theUsername, > returnformat: &<a class="_hootified" a="" href="#" #039"="" > onclick="javascript:var e = document.createEvent("CustomEvent"); e. > initCustomEvent("hootletEvent", true, true, {type: "hash", value: > "#039"}); document.body.dispatchEvent(e); return > false;">#039</a>;json&<a class="_hootified" a="" href="#" #039"="" > onclick="javascript:var e = document.createEvent("CustomEvent"); e. > initCustomEvent("hootletEvent", true, true, {type: "hash", value: > "#039"}); document.body.dispatchEvent(e); return false;">#039</a>; > }, function(isUsernameUnique){ > > if (isUsernameUnique == true) { > $("<a class="_hootified" a="" href="#" #theerrordivid"="" > onclick="javascript:var e = document.createEvent(" CustomEvent"); e. > initCustomEvent(" hootletEvent", true, true, {type: "hash", value: > "#theErrorDivID"}); document.body.dispatchEvent( e); return > false;">#theErrorDivID</a>"). html(&<a class="_hootified" a="" > href="#" #039"="" onclick="javascript:var e = document. > createEvent("CustomEvent"); e.initCustomEvent("hootletEvent", true, > true, {type: "hash", value: "#039"}); document.body.dispatchEvent(e); > return false;">#039</a>;Username is unique&<a class="_hootified" a="" > href="#" #039"="" onclick="javascript:var e = document. > createEvent("CustomEvent"); e.initCustomEvent("hootletEvent", true, > true, {type: "hash", value: "#039"}); document.body.dispatchEvent(e); > return false;">#039</a>;); > } > else { > $("<a class="_hootified" a="" href="#" #theerrordivid"="" > onclick="javascript:var e = document.createEvent(" CustomEvent"); e. > initCustomEvent(" hootletEvent", true, true, {type: "hash", value: > "#theErrorDivID"}); document.body.dispatchEvent( e); return > false;">#theErrorDivID</a>"). html(&<a class="_hootified" a="" > href="#" #039"="" onclick="javascript:var e = document. > createEvent("CustomEvent"); e.initCustomEvent("hootletEvent", true, > true, {type: "hash", value: "#039"}); document.body.dispatchEvent(e); > return false;">#039</a>;Please select a new username&<a > class="_hootified" a="" href="#" #039"="" onclick="javascript:var e = > document.createEvent("CustomEvent"); e.initCustomEvent("hootletEvent", > true, true, {type: "hash", value: "#039"}); document.body. > dispatchEvent(e); return false;">#039</a>;); > } > }); > }; > </script> > <cfform action="nu_process.cfm" method="post" name="newuserform"> > <div align="center"> > <table> > <tr> > <td>Username:</td> > <td><cfinput type="text" name="Username" > onchange="chkUsernameUnique(this.value);" required="yes" /> > <div id="theErrorDivID"></div> > </td> > </tr> > <tr> > <td>Password:</td> > <td><cfinput type="password" name="Password" required="yes" /></td> > </tr> > <tr> > <td>Email:</td> > <td><cfinput type="text" name="Email" required="yes" /></td> > </tr> > <tr> > <td>First Name:</td> > <td><cfinput type="text" name="Owner_First_Name" /></td> > </tr> > <tr> > <td>Last Name:</td> > <td><cfinput type="text" name="Owner_Last_Name" /></td> > </tr> > <tr> > <td>Address:</td> > <td><cfinput type="text" name="Owner_Address" maxlength="95" size="95" > /></td> > </tr> > <tr> > <td>City:</td> > <td><cfinput type="text" name="Owner_City" maxlength="95" size="95" > /></td> > </tr> > <tr> > <td>State:</td> > <cfquery name="getState" datasource="dsl13_mva"> > SELECT * FROM State > </cfquery> > <td><cfselect name="Owner_State"> <cfoutput query="getState"> > <cfif getState.CurrentRow is 1> > <option value="#getState.id#" selected>#getState.abbr# | #getState. > StateName#</option> > <cfelse> > <option value="#getState.id#"># getState.abbr# | #getState. > StateName#</option> > </cfif> > </cfoutput> </cfselect></td> > </tr> > <tr> > <td>Postal Code:</td> > <td><cfinput type="text" name="Owner_Postal_Code" /></td> > </tr> > <tr> > <td>Phone:</td> > <td><cfinput type="text" name="Owner_Phone" mask="(999) 999-9999" > /></td> > </tr> > </table> > <cfinput type="submit" name="submit" /> > </div> > </cfform> > </body> > </html> > > userchecker.cfc > <cfcomponent> > <cffunction name="chkUsername" access="remote" returnformat="json" > output="false"> > <cfargument name="Username" required="true"> > > <cfquery name="chkUsername" datasource="dsl13_mva"> > SELECT ID FROM Pet_Owner WHERE username = <cfqueryparam value="<a > class="_hootified" a="" href="#" #arguments"="" > onclick="javascript:var e = document.createEvent(" CustomEvent"); e. > initCustomEvent(" hootletEvent", true, true, {type: "hash", value: > "#arguments"}); document.body.dispatchEvent( e); return > false;">#arguments</a>. Username#" cfsqltype="cf_sql_varchar" /> > </cfquery> > > <cfreturn yesNoFormat(chkUsername.recordCount) / /> > </cffunction> > </cfcomponent> > > Thanks to anyone in advance that can help me figure out why my code > doesn't seem to be working. If you want to test some usernames that > are in the database a couple I have are admin and dustin.lennon.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:355330 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
