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: > > >> > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274162 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
