How do I trap errors when someone fills out my form and enters in a username (for example) that is already in the database. Right now, the database throws this back:
Cannot insert duplicate key row in object 'USERS' with unique index 'IX_USERS_1'.
And that's lame. I want to pop-up a dialog or something. Can that be done?
PS: I am using Dreamweaver MX 2004 and its built-in bahaviors if that matters.