Re: sql query works in database connector but not in ZSQL method

"M.-A. Lemburg" <[email protected]>
Newsgroups gmane.comp.web.zope.database
Organization eGenix.com Software GmbH
Message-ID <[email protected]>
On 2007-01-17 17:42, Charlie Clark wrote:
> Am 17.01.2007, 17:14 Uhr, schrieb robert rottermann <[email protected]>:
> 
>> If tried that, but somehow I did not get it rigth:
>> questions:
>> - - the first parameter is an integer, how do I force that?
> 
> int(para) ?
> 
>> - - the second parameter is an out parameter, how do I specify that ?
> 
> You don't, I think we don't support them currently.

That's correct. You will have to wrap the stored procedure you're
calling in another one that returns the data via a standard SELECT
and then access the value using the result set.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source  (#1, Jan 17 2007)
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________

::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.