> Firstly, the column in the table absoutley *should* have a unique
> index or constraint on it. Doing that will avoid any racing as the db
> will make it impossible to insert dupes.
I actually wasn't saying it shouldn't have a unique constraint, just
that if you're using cflock to handle the looping and checking, then the
system will never actually reach a point at which the unique index
becomes relevant, because the lock will prevent it from even attempting
to insert any dup's.
--
s. isaac dealey ^ new epoch
isn't it time for a change?
ph: 503.236.3691
http://onTap.riaforge.org/blog
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to
date
Get the Free Trial
http://ad.doubleclick.net/clk;160198600;22374440;w
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:298814
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
