RE: Sql Server Temp Table

2006-05-09 Thread Brian Peddle
Just odd. -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&#x

Re: Sql Server Temp Table

2006-05-09 Thread Neil Middleton
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

Re: Sql Server Temp Table

2006-05-09 Thread Andy Mcshane
ent: 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 '#tem

RE: Sql Server Temp Table

2006-05-09 Thread Munson, Jacob
> -Original 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 > alr

Re: Sql Server Temp Table

2006-05-09 Thread Rob Wilkerson
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

Sql Server Temp Table

2006-05-09 Thread Brian Peddle
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 servic