The create is like this
SELECT fields into ##temp_report
drop table ##temp_report
is done at the end.
Temp tables like this are dropped after the connection has ended no matter
what so the drop usually isn't need but nice for cleanup.
I would have thought cycling the CF services would have cured anything
lingering as well as the cycle of SQL Server but it just don't go away. We
use temp tables in a bunch of other reports with no issues. Just this one
has an issue all of a sudden.
And the SQL statement is valid as I can run it in Query Analyzer. 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'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 PROTECTED]> wrote:
> > 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
> > services in hopes to break any connections, I also recycled the SQL
> Server
> > service and still no luck.
> >
> > Any insight?
> >
> >
> >
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:240000
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
