[egenix-users] Re: [Plone-users] Re: [Zope-DB] MS SQL stored procedures andMXODBCDA - supposedly NO RESULTS

[M.-A. Lemburg]

Peter Millar wrote:
> Thanks for the suggestions Marc-Andre,
> 
> I am calling the stored procedure using the ODBC driver correctly
> because I can call other stored procedures with parameters and they work
> perfectly well ... But this stored procedure doesn't return the results
> for some reason that I cannot determine.
> 
> P.s. sorry for posting to multiple lists but not sure if this is an
> mxODBC ZDA question or an zope da question.

Provided you are using the mxODBC Zope DA, I can assure
you that in case the stored procedure does create a
result set, then it will return this to Zope.

If there are multiple result sets, the Zope DA will
return the first available set unless you set the
option to fetch the last available result set.

It is possible that the stored procedure creates
an empty result before the final SELECT you have
in the code.
  ____________________________________________
> Peter Millar 
> 
> 
> -----Original Message-----
> From: plone-users-admin at lists.sourceforge.net
> [mailto:plone-users-admin at lists.sourceforge.net] On Behalf Of M.-A.
> Lemburg
> Sent: Wednesday, 30 June 2004 5:43 PM
> To: Peter Millar
> Cc: egenix-users at lists.egenix.com; Zope-DB at zope.org;
> plone-users at lists.sourceforge.net
> Subject: Re: [Plone-users] Re: [Zope-DB] MS SQL stored procedures and
> MXODBCDA - supposedly NO RESULTS
> 
> 
> Peter Millar wrote:
> 
>>There are no errors that is part of the problem ... I simply get a 
>>message 'no results returned'
>>
>>Yet there are results.
> 
> 
> Perhaps your call syntax is wrong ?! Please check your
> ODBC driver documentation on how to call stored procedures
> and whether you have to enable any special ODBC options
> on your driver to have it fetch the entire result set
> before dropping the table.
> 
> Please also avoid these cross-posts to multiple lists.
> Zope DA are best discussed on zope-db. For eGenix products
> you can also use egenix-users.
> 
> Thanks,

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jul 01 2004)
 >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
 >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
 >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
IL Workshop @ Net.ObjectDays 2004, Erfurt, Germany          87 days left

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::