well you cant maintain a transaction which accesses 2 different databases anyway
each transaction block has to be within the same database -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Bryan Nolen Sent: Sunday, February 15, 2004 9:57 PM To: CFAussie Mailing List Subject: [cfaussie] Re: cfc's and cftransactions Its an ecommerce site - card data, shopper info and cart data all goes into different tables (and two different databases actually), but I want it all wrapped in a transaction in case one of the three inserts fail. Hmmm side question: can you call multiple inserts from one ? Probably not. -Bryan > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of barry.b > Sent: Sunday, 15 February 2004 9:50 PM > To: CFAussie Mailing List > Subject: [cfaussie] Re: cfc's and cftransactions > > > just a thought... > > aren't you just re-inventing the idea of cftransaction anyway? > > what's wrong with passing an object (structure or even an array of > structs) to the insert method - which has a transaction > around that. It's > only called once and if it's an array of structs you just > loop over all of > the array elements inserting as you go (from 1 to len(array)). > > the only grief I'd see is if you wanted to put some logic around each > insert - that'd be a pain... > > my 2c worth > barry.b > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
