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: > >> > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274160 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
