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
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
