>> Alternatively i could attempt to insert a duplicate email >> address and catch any database error generated as a result.
> If you can detect whether an insert errors because of the > unique index that would be my choice. Ideally that would be my answer also ... in practical terms, I'm always concerned that I won't be able to properly identify the difference between an error created because of the condition I want to trap and an error created by something else... Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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
