> 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 Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
