this is something I have used in the past
<cfquery datasource="u8ntcn0">
Insert into events(EventName)
Values('testing')
</cfquery>
<cfquery datasource="u8ntcn0" name="test">
select @@identity as ID_num
</cfquery>
<cfoutput query="test">
#ID_num#
</cfoutput>
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
