Try turning the NOCUNT OFF right before the "SELECT * FROM ##xyz" then back on for the drop?
Just a SWAG, perhaps it is similar to resultsets from stored procedures... Matthew P. Smith Web Developer, Object Oriented Naval Education & Training Professional Development & Technology Center (NETPDTC) (850)452-1001 ext. 1245 [EMAIL PROTECTED] >>-----Original Message----- >>From: Rob Rohan [mailto:[EMAIL PROTECTED]] >>Sent: Monday, October 07, 2002 12:21 PM >>To: CF-Talk >>Subject: Big Trouble in T-SQL land >> >>This move to MX has been quite the learning experience. >> >>Now, we seem to be unable to create temporary tables. The following query >>returns 0 records in CFMX but 1 record in query analyzer. >> >>Anyone else? Suggestions? Glass of hemlock? >> >><CFQUERY NAME="test" DATASOURCE="foobardb" DBTYPE="ODBC"> >>SET NOCOUNT ON >> >>CREATE TABLE ##xyz (a varchar(10)) >> >>INSERT INTO ##xyz ( >> a >>)VALUES ( >> 'foo' >>) >> >>SELECT * FROM ##xyz >> >>DROP TABLE ##xyz >> >>SET NOCOUNT OFF >></CFQUERY> >> >>We are using MX with SQL 7. >> >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting.