Select the count of those that have those credentials and if the number is greater than zero, return an error, otherwise do your insert.
From: [email protected] [mailto:[email protected]] On Behalf Of stinasius Sent: Friday, March 27, 2009 10:19 AM To: [email protected] Subject: [flexcoders] Preventing duplicate database entries in ColdFusion and flex how can i prevent duplicate database entries in coldfusion and flex. for example for registration forms, i would like that if someone registers the same combination of username and password that already exist in the db, the entry is rejected and the user is alerted. thanks
