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: > Jon, > I was thinking the same thing. Can I just wrap the entire > transaction part in a cflock tag? I guess I naively thought that > the cftransaction tag would have the same effect but obviously I > was mistaken. > > Gerald > >> Gerald, >> >> It looks to me like a SPAM bot. Many times they will send multiple >> POST requests at once to gather vailid emails or attempt to use your >> forms to spam others. If that is the case it may be that your >> "checkEmail" isn't working because the "add to Email" query hasn't >> run. Have you tried putting a <cflock> around your code to >> prevent simulateous requests/updates to that table? >> >> Jon >> >> On Sep 27, 2006, at 11:17 AM, 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:254443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
