Can I advise?
Some minor changes:
<cfquery name="insertRecord" datasource="#mydsn#">
insert into table(name,UserInsertedID)
values('#form.name#', #session.UserID#)
</cfquery>
<cfquery name="getMax" datasource="#mydsn#">
select tableID
from table
where name = '#form.name#'
and UserInsertedID = #session.UserID#
Order by tableID
</cfquery>
<cfset tableID = getMax.TableID[1]>
This should work in multiuser environment.
Cheers,
Gennadi
------------------------------------------------------------------------------
To unsubscribe, send a message to [EMAIL PROTECTED] with
'unsubscribe' in the body or visit the list page at www.houseoffusion.com
