> I thought you have to committ the transaction as well? > > I've had SQL problems using this syntax w/o a commit..
By default, if you simply have an opening and closing CFTRANSACTION tag, you don't need to explicitly commit - the CFTRANSACTION tag will do that all by itself. CF 4.5 introduced the ability to place nested CFTRANSACTION tags with the ACTION attribute of COMMIT or ROLLBACK within a larger CFTRANSACTION, but that simply allows you do perform partial commits and rollbacks if desired. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-544 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists