EasyCFM.COM - The ColdFusion Community! About Us!

Senior Member
Posts: 376
Joined: Feb 2005

Hello,

I have a signup page connected to an SQL database, how can I check to make sure that the person typed in a unique username?

Thanks,
Jamie

Sirseth

Sivart

01-01-2006 @ 6:27 PM

Senior Member
Posts: 235
Joined: Apr 2004

Query the qb for that name


<CFIF IsDefined ("FORM.us_userName")>

<cfquery name="dupUserName" datasource="#datasource#">
SELECT us_userName
FROM tbl_users
WHERE us_userName = '#FORM.us_userName#'
</cfquery>
<cfif>

then

<cfif 'dupUserName.recordcount' GT "0">
username alreadyt in use
<cfelse>
username avail
</cfif>

hope that helps
-Sivart

Sirseth

01-01-2006 @ 6:43 PM

Senior Member
Posts: 376
Joined: Feb 2005

2 Things happen that I cant seem to fix

1. When page first loads, triggers my messagebox telling the user "username already exists"

2. When name already exists, and I click 'Signup' and it comes back to that page, the user have to re-type in all values,

<cfif IsDefined ("FORM.Artist_UserName")>
     <cfquery name="dupUserName" datasource="Tzome" username="Tzome_Admin" password="Tzome">
     SELECT Artist_UserName
     FROM Tzome_Artists
     WHERE Artist_UserName  = '#FORM.Artist_UserName#'
     </cfquery>
</cfif>

<cfif 'dupUserName.recordcount' GT "0">


<InvalidTag LANGUAGE="JavaScript">
     {
     alert("Username Already Exists.")
     }
</SCRIPT>

<cfelse>
     <cfif IsDefined("FORM.MM_InsertRecord") AND FORM.MM_InsertRecord EQ "form1">

       <cfquery datasource="Tzome" username="Tzome_Admin" password="Tzome">
          INSERT INTO Tzome_Artists (Artist_UserName, Artist_Password, Artist_Confirm, Artist_Email, Artist_ReEmain, Artist_Eula, Artist_CurrentEarnings, Artist_LastPayout)
          VALUES (
       <cfif IsDefined("FORM.Artist_UserName") AND #FORM.Artist_UserName# NEQ "">
          '#FORM.Artist_UserName#'
            <cfelse>
          NULL
       </cfif>
          ,
       <cfif IsDefined("FORM.Artist_Password") AND #FORM.Artist_Password# NEQ "">
          '#FORM.Artist_Password#'
            <cfelse>
          NULL
       </cfif>
          ,
       <cfif IsDefined("FORM.Artist_Confirm") AND #FORM.Artist_Confirm# NEQ "">
          '#FORM.Artist_Confirm#'
            <cfelse>
          NULL
       </cfif>
          ,
       <cfif IsDefined("FORM.Artist_Email") AND #FORM.Artist_Email# NEQ "">
          '#FORM.Artist_Email#'
            <cfelse>
          NULL
       </cfif>
          ,
       <cfif IsDefined("FORM.Artist_ReEmain") AND #FORM.Artist_ReEmain# NEQ "">
          '#FORM.Artist_ReEmain#'
            <cfelse>
          NULL
       </cfif>
          ,
       <cfif IsDefined("FORM.Artist_Eula") AND #FORM.Artist_Eula# NEQ "">
          '#FORM.Artist_Eula#'
            <cfelse>
          NULL
       </cfif>
          ,
       <cfif IsDefined("FORM.Artist_CurrentEarnings") AND #FORM.Artist_CurrentEarnings# NEQ "">
          '#FORM.Artist_CurrentEarnings#'
            <cfelse>
          NULL
       </cfif>
          ,
       <cfif IsDefined("FORM.Artist_LastPayout") AND #FORM.Artist_LastPayout# NEQ "">
          '#FORM.Artist_LastPayout#'
            <cfelse>
          NULL
       </cfif>
          )
       </cfquery>
       <cflocation url="WaitPage.cfm">
     </cfif>

</cfif>

Sirseth

Sirseth

01-01-2006 @ 6:46 PM

Senior Member
Posts: 376
Joined: Feb 2005

Also no matter what, even if unique username, it still tells me I need a unique username.

and does not add record.

Thanks
jamie!!

Sirseth

Sirseth

01-01-2006 @ 8:08 PM