MS SQL temporary table not working

[numbered]

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

 

[philhege]

Seven,

Session-specific temporary tables are prefaced with one pound sign:

#Mytemporarytable

You may still have problems because of connection pooling. Try to name the table something unique to the session. Incorporate a GUID value into its name.

HTH,

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
Boy howdy, my Liberal Studies degree really prepared me for this....
-----------
A skeleton walks into a bar, and says "I'll have a beer and a mop.