Thanks for you help Paul. Actually, this doesn't fail in cf5. The SET NOCOUNT allows for multi sql statements (in MS SQL). Thanks for your suggestion on checking for objects, but as I am sure you can tell this is only a sample bit of code to explain our problem. This is not on our site.
This type of query is used a lot on our site and in cf5 there was no problem. Moving to a stored proc does fix the problem; however, that is an impossibility with some of our queries - plus it would be a major re-write. -----Original Message----- From: Paul Hastings [mailto:[EMAIL PROTECTED]] Sent: Saturday, October 05, 2002 12:49 AM To: CF-Talk Subject: Re: Big Trouble in T-SQL land > Now, we seem to be unable to create temporary tables. The following query > returns 0 records in CFMX but 1 record in query analyzer. no, it looks like the CREATE TABLE in the same cfquery. fails with "regular" tables too. > Anyone else? Suggestions? Glass of hemlock? move this into an SP. works there as expected. > CREATE TABLE ##xyz (a varchar(10)) btw you should always check for objects prior to creating them just in case a process croaks & leaves that table or whatever hanging about. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.394 / Virus Database: 224 - Release Date: 10/3/2002 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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 Get the mailserver that powers this list at http://www.coolfusion.com
