> hey guys, I have inserted a record into a table, > and did the SELECT @@identity as Ident thing. the thing is
provided your table has an identity column: SET NOCOUNT ON INSERT someTable(someColumns) VALUES (#form.someValues#) SELECT lastID=@@IDENTITY SET NOCOUNT OFF ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
