ahhh..true...i shouldn't be responding to posts while working. Thread from January about the same concepts...
http://www.houseoffusion.com/groups/cf-talk/thread.cfm/threadid:44021 On 3/29/07, James Holmes <[EMAIL PROTECTED]> wrote: > If this DB defaults to read-committed, that's not always going to > yield consistent results. Serializable is the only way to be sure. > > Of course, with MySQL, this all only applies if the table type is > InnoDB, since MyISAM doesn't support transactions at all. > > On 3/30/07, Ken Wexel <[EMAIL PROTECTED]> wrote: > > If you are simply inserting a new record, then doing a select max type > > operation to determine the id, you shouldn't need to specify the > > isolation level, as the default will work...e.g. > > > > <cftransaction> > > > > <cfquery name="whatever" datasource="mydsn"> > > INSERT INTO(.....) > > </cfquery> > > > > <cfquery name="getMyWhateverID" datasource="mydsn"> > > SELECT MAX(field) AS intNewID > > FROM someTable > > </cfquery> > > > > </cftransaction> > > > > -Ken > > > > > > On 3/29/07, Matthew Chambers <[EMAIL PROTECTED]> wrote: > > > Ok, but what CFTRANSACTION type do I use? > > > > > > Cheers > > > Matthew > > > > > > >If msql4 supports transactions then you have no problems. That's what > > > >transactions is all about, multiple queries that rely on one or another > > > >failing, to summarise it up. > > > > > > > > > > > >On 3/29/07, Matthew Chambers <[EMAIL PROTECTED]> wrote: > > > >> > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274165 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4