Hi Jon, I'll give that a try. I was astounded just now that when I went to our site and tried to sign up for the newsletter I tried to just keep clicking on the SUBMIT button and low-and-behold I see my email address in the database 6 times in a row. I thought that was a submit button was pushed that was it! Guess not.
I'll try this cflock approach. Jerry >I would suggest wrapping from the before the beginning of the e-mail >check query to the end of the insert query. You simply want to lock >that block from being executed by another user. Then your <cfmail> >transaction, which may take a bit longer, isn't under lock if you >have concurrent users. > ><cftransaction> allows you to rollback in the event of a failure you >designate. It doesn't, however lock anything. > >Jon > >On Sep 27, 2006, at 12:56 PM, Gerald Weir wrote: > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:254509 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
