I'm trying to work with temporary tables using MS sql and coldfusion. It's not working the way it should.
<cfquery name="tempTableCreate" datasource="#application.dataSource#">
CREATE TABLE ##table(
id int IDENTITY(1,1) PRIMARY KEY,
value1 smalldatetime NULL,
value2 varchar(5) NULL)
</cfquery>
The problem is that the same temp table exists for all sessions. I need it to be unique for each session. It's only suppose to be active for as long as the connection is live. In coldfusion you don't close a connection. How do I use temp tables with coldfusion?
Thank you,
Seven
<cfquery name="tempTableCreate" datasource="#application.dataSource#">
CREATE TABLE ##table(
id int IDENTITY(1,1) PRIMARY KEY,
value1 smalldatetime NULL,
value2 varchar(5) NULL)
</cfquery>
The problem is that the same temp table exists for all sessions. I need it to be unique for each session. It's only suppose to be active for as long as the connection is live. In coldfusion you don't close a connection. How do I use temp tables with coldfusion?
Thank you,
Seven