> this variable will safely return the value of the identity field. If you > are using CFquery, block the insert and select code into a single <cfquery>
within a SET NOCOUNT ON/OFF block.... > or if using two queries, use cf transaction. no, that won't guarantee you'll get the @@IDENTITY. the 1st method is "classic". ______________________________________________________________________ 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
