Peter Theobald wrote: > At 04:33 PM 8/28/2003 -0700, Barney Boisvert wrote: > >>I strongly suspect that a given page request has exclusive access to a given >>connection for the length of it's processing. MM has confirmed that all >>queries by a single request are passed over the same connection. > > I doubt this could be true.
Search the archives. >>The best solution is to use a CFTRANSACTION block, but unless you're using a >>BDB table, that won't work. InnoDB will let you do it as well, but you said >>you weren't using those. > > Honestly, I never understood how CFTRANSACTION differs from SQL 'begin > transaction... commit' It doesn't. The question is whether whichever table handler you are using will throw an error when you use a transaction anyway. If it doesn't this is probably the best solution (apart from using real transactions). Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:4 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
