ColdFusion

autocreate username

Please support our ColdFusion advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Aug 2008

Posts: 1

Reputation: mkwebnovice is an unknown quantity at this point

Solved Threads: 0

mkwebnovice mkwebnovice is offline

Offline

Newbie Poster

autocreate username

Aug 11th, 2008

can anyone help me with code to auto carete a username.
this should tahe the 4 letters of the user's name and assign a number from a sequence in a database.
basically the username should be like "comp001" but it should verify if it exists in the database. please help. im new to coldfusion

•

Join Date: Feb 2008

Posts: 72

Reputation: cmhampton is an unknown quantity at this point

Solved Threads: 10

cmhampton

Offline

Junior Poster in Training

Re: autocreate username

Aug 20th, 2008

Here's something to start with. To get the first four characters of the user's name, use the LEFT function. Assuming you have a text box on the form called 'txtName':

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
<cfset username = LEFT(form.txtName, 4) />
<cfset username = LEFT(form.txtName, 4) />

If the name entered in that field was 'mkwebnovice', this would give you 'mkwe'. Next, you can use the MAX function in SQL (provided you are using SQL) to get the highest ID record in your user's table. I am of course assuming that you have a users table with an auto incrementing id field. When you do your insert statement, use this function and combine it with the result of the LEFT function above.

 Help with Code Tags 
 ColdFusion Syntax (Toggle Plain Text) 
<cfquery datasource="whatever your datasource is" name="qryGetMaxUserID">
  DECLARE @userID varchar(10);
  SELECT @userID = CAST((SELECT MAX(userID) + 1 AS newUserID FROM users) AS varchar(10));
 
  INSERT
    users
    (
       username
    )
VALUES
    (
      '#username#' + @userID
    )
</cfquery>
<cfquery datasource="whatever your datasource is" name="qryGetMaxUserID">
  DECLARE @userID varchar(10);
  SELECT @userID = CAST((SELECT MAX(userID) + 1 AS newUserID FROM users) AS varchar(10));

  INSERT
    users
    (
       username
    )
VALUES
    (
      '#username#' + @userID
    )
</cfquery>