When you have a "No Duplicates" field in the database and a duplicate is entered, CF 
returns somewhat of a weird error message. How do you get it to return an error 
message saying "This UserName is already in use, choose another." UserName being the 
"No Duplicates" field. Here is my action cfm:

*********************************************************

<cfquery datasource="DSN" name="AddUser">
INSERT INTO Users (UserName, RealName, Email)
VALUES ('#UserName#','#RealName#','#Email#')
</cfquery>

*********************************************************

Thanks in advance,

Jeremy

------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebarRsts&bodyRsts/cf_talk or send a message 
to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to