<!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 Server, Zsql and stored procedures</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Courier New">Hi all zsql experts.</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">Running Plone 2.0, MS SQL Server, egenix MXODBC</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">I have a simple stored procedure and from my zsql method I can run it and it works perfectly.</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">I have another that requires parameters. How do I call this passing the parameters??</FONT>
</P>
<P><FONT SIZE=2 FACE="Courier New">I have tried </FONT>
<BR><FONT SIZE=2 FACE="Courier New">Zsql = dbo.usp_getmystuff 'abc','123','456' </FONT>
<BR><FONT SIZE=2 FACE="Courier New">Zsql = dbo.usp_getmystuff <dtml-sqlvar sdate type=string> <dtml-sqlvar edate type=string> <dtml-sqlvar name type=string></FONT></P>
<P><FONT SIZE=2 FACE="Courier New">But these don't work ... I get errors each time ... Or if I hard code the parameters in the zsql method I get no results returned and yet ofcourse I have tested my stored procedure and it works and there are lots of results.</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>
</P>
</BODY>
</HTML>