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