<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.0.4630.0">
<TITLE>MS SQL stored procedures and MXODBCDA - supposedly NO RESULTS</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">How come when I run my stored procedure from the query analyzer I get a swag of results but if I run it from zope I get no results returned. </FONT></P>
<P><FONT SIZE=2 FACE="Arial">Is it because the odbc driver or zsql cannot handle such a simple stored procedure as this one where a temporary table is created, populated, queried, and finally dropped.</FONT></P>
<BR>
<P><FONT SIZE=2 FACE="Arial">CREATE PROC myState </FONT>
<BR><FONT SIZE=2 FACE="Arial">@StartDate DateTime, </FONT>
<BR><FONT SIZE=2 FACE="Arial">@EndDate DateTime, </FONT>
<BR><FONT SIZE=2 FACE="Arial">@Name varchar(256)</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">AS</FONT>
<BR><FONT SIZE=2 FACE="Arial">--Create a temporary table containing the history data</FONT>
<BR><FONT SIZE=2 FACE="Arial">CREATE TABLE #DisAgg (name varchar(256), dt datetime, value int)</FONT>
<BR><FONT SIZE=2 FACE="Arial">INSERT #DisAgg</FONT>
<BR><FONT SIZE=2 FACE="Arial"> SELECT name, DateTime, Value</FONT>
<BR><FONT SIZE=2 FACE="Arial"> FROM y</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">SELECT </FONT>
<BR><FONT SIZE=2 FACE="Arial">b.name,</FONT>
<BR><FONT SIZE=2 FACE="Arial">b.dt as enddate, </FONT>
<BR><FONT SIZE=2 FACE="Arial">FROM #DisAgg b </FONT>
<BR><FONT SIZE=2 FACE="Arial">WHERE b.value = 0</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">--Drop temporary tables</FONT>
<BR><FONT SIZE=2 FACE="Arial">Drop table #DisAgg</FONT>
</P>
<P><FONT COLOR="#0000FF" SIZE=1 FACE="Verdana">____________________________________________</FONT><BR>
<B></B><B><FONT COLOR="#0000CC" SIZE=2 FACE="Verdana">Peter Millar</FONT></B><FONT COLOR="#0000CC" SIZE=2 FACE="Verdana"></FONT><BR>
<B><FONT COLOR="#808080" SIZE=1 FACE="Verdana">Technical Project Manager</FONT></B><FONT COLOR="#808080" SIZE=1 FACE="Verdana"></FONT><BR>
<B><FONT COLOR="#0000CC" SIZE=1 FACE="Verdana">Parasyn Controls Pty Ltd</FONT></B><FONT COLOR="#0000CC" SIZE=1 FACE="Verdana"><BR>
<BR>
</FONT><A HREF="mailto:Peter.Millar@Parasyn.com.au"><U></U><U><FONT COLOR="#0000FF" SIZE=1 FACE="Verdana">Peter.Millar@Parasyn.com.au</FONT></U></A><FONT COLOR="#0000CC" SIZE=1 FACE="Verdana"><BR>
</FONT><FONT COLOR="#000000" SIZE=1 FACE="Verdana">T: 61 7 3396 6388<BR>
F: 61 7 3396 6299<BR>
45 Millenium Place, Tingalpa QLD 4173<BR>
PO Box 400 Cannon Hill QLD 4170</FONT><BR>
<B><FONT COLOR="#0000CC" SIZE=1 FACE="Verdana">Australia</FONT></B><FONT COLOR="#0000CC" SIZE=1 FACE="Verdana"><BR>
</FONT><A HREF="http://www.parasyn.com.au/"><U></U><U><FONT COLOR="#0000FF" SIZE=1 FACE="Verdana">www.parasyn.com.au</FONT></U></A><FONT COLOR="#0000CC" SIZE=1 FACE="Verdana"></FONT>
</P>
</BODY>
</HTML>