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.
Rob
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
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.
