> Ok I don't think the ODBC drivers I have support the > cftransaction, how can I be sure though, there isn't > an error message. If I am updating a record and I > rollback at the end, it should go back to the number > it was before, correct? Or does it only work for > inserts.
Yes, if you make a change, then rollback that change, the record should contain the values it had before the transaction began. You might try a different ISOLATION attribute; maybe the default is too "loose". I'd try ISOLATION="serializable", and see what happens then. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
