> We are currently using a <CFTRANSACTION> wrapped around a > CFINSERT and query getting back the New ID of the new record > created . . doesn't seem to hold up . . .
If you're using a database like SQL Server, simply wrapping both within a CFTRANSACTION won't matter. The CFINSERT, or any SQL INSERT, won't lock the entire table, and in fact will probably only lock the row into which the record is inserted. So, if someone else inserts a record, it won't affect the transaction. Your final query, however, simply retrieves the last row inserted. You might consider using a stored procedure or trigger to handle this, instead. Dave Watts, CTO, Fig Leaf Software http://www.figleaf.com/ voice: (202) 797-5496 fax: (202) 797-5444 ______________________________________________________________________ Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusiona 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
