Hi I would like to know if constraints other than keys are usually used? I have a database where the email address must be unique and was wondering if a constraint should be used. I could check for the existence of an email address prior to inserting a new record but this involves another query. Alternatively i could attempt to insert a duplicate email address and catch any database error generated as a result. I'm just wondering which method is best. Also the database will only be used with this CF application.
thanks Kola ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
