Sorry, got my wires crossed on that one. I still prefer the UUID approach (or use a stored procedure - not available in Access).
- Calvin -----Original Message----- From: Dave Watts [mailto:[EMAIL PROTECTED] Sent: Monday, January 31, 2005 3:00 PM To: CF-Talk Subject: RE: grabbing the id of a newly created item.. > In either case, cftransaction isn't guaranteed (it's only a > recommendation, and does it work with Access?) ... I don't think this is correct. When you specify BEGIN TRANSACTION within an SQL batch (which is the raw SQL equivalent of the CFTRANSACTION tag), it isn't a recommendation, but rather will force the database to apply transactional processing rules based on the isolation level (which is SERIALIZABLE by default with CFMX, apparently). And yes, CFTRANSACTION works with Access just like with any other database. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ Fig Leaf Software provides the highest caliber vendor-authorized instruction at our training centers in Washington DC, Atlanta, Chicago, Baltimore, Northern Virginia, or on-site at your location. Visit http://training.figleaf.com/ for more information! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:192427 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
