Today I just started to get an error:
[Macromedia][SQLServer JDBC Driver][SQLServer]There is already an object
named '#temp_reports' in the database.
If I take the query from coldfusion and run in analyzer it works as
expected, it is just inside CF that I have the issue. I recycled the CF
I'm having to work to establish recall, here, but I thought I
remembered that temp tables were maintained until the connection is
broken. Do you have Maintain Connections checked in your DS
properties, by any chance? Has anything else changed in the
environment?
On 5/9/06, Brian Peddle [EMAIL
Message-
From: Brian Peddle [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 09, 2006 10:52 AM
To: CF-Talk
Subject: Sql Server Temp Table
Today I just started to get an error:
[Macromedia][SQLServer JDBC Driver][SQLServer]There is
already an object
named '#temp_reports' in the database
: Sql Server Temp Table
Today I just started to get an error:
[Macromedia][SQLServer JDBC Driver][SQLServer]There is
already an object
named '#temp_reports' in the database.
If I take the query from coldfusion and run in analyzer it works as
expected, it is just inside CF that I
Are you guys sure you aren't talking about ##temp_table?
On 5/9/06, Rob Wilkerson [EMAIL PROTECTED] wrote:
I'm having to work to establish recall, here, but I thought I
remembered that temp tables were maintained until the connection is
broken. Do you have Maintain Connections checked in
.
-Original Message-
From: Neil Middleton [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 09, 2006 2:37 PM
To: CF-Talk
Subject: Re: Sql Server Temp Table
Are you guys sure you aren't talking about ##temp_table?
On 5/9/06, Rob Wilkerson [EMAIL PROTECTED] wrote:
I'm having to work to establish recall
6 matches
Mail list logo