[egenix-users] trouble with intermediary results sets and Zope DA

[Erik Myllymaki]

I am moving from Zope 2.3.2 on Windows NT 4.0, w ZODBCDA->MSSQL7.0 SP3 
to Zope 2.7 on Win2k w mxODBCDA->SQL Server 2000 SP3a.

I am getting the following error from a query that worked well on the 
there machine:

Error Type: ValueError
Error Value: only the last statement in an SQL batch may generate a 
result set

the query looks something  like this(simplified):

 select * into #temp_table1 from some_table
<dtml-var sql_delimeter>
select * into #temp_table2 from some_other_table
<dtml-var sql_delimeter>
select * from
#temp_table1 t1
join
 #temp_table2 t2
on
t1.id = t2.id
<dtml-var sql_delimeter>
drop table #temp_table1
<dtml-var sql_delimeter>
drop table #temp_table2



Thanks for any advice