[Zope-DB] MaxDB Problems - Pls Help

[Dieter Maurer]

Samir Mishra wrote at 2004-1-13 08:43 +0400:
> ...
>I'm using MaxDB with Zope 2.6.1 (binary release, python 2.1, win32-x86),
>python 2.1.3, win32), ZsapdbDA 0.3 and latest SAPDB Python modules.
> ...
>6. select BANKBIC, BANKNAME, BANKTYPE from BANKINFO
>   where ( BANKBIC in ('ADCB', 'NBAD') ) 
>
>The last query gives me 2 records, one for each code, which is the primary
>key on the table.
>
>
>
>Now for the problem part -- the following queries are failing to return any
>records --
>
>1. select BANKBIC, BANKNAME, BANKTYPE from BANKINFO
>   where ( BANKBIC in ('ADCB') ) 
>
>2. select BANKBIC, BANKNAME, BANKTYPE from BANKINFO
>   where ( BANKBIC = 'NBAD' ) 
>
>I get the message "There was no data matching this Z sapdb Database
>Connection (connected) query." Which I know is not true.

For me, it looks as if it were not a Zope issue.

To find out for sure who is responsible, I would
add logging to "ZsapdbDA" (usually the "query" method in "db.py")
to learn what SQL Zope sends to the database and what
the database returns.

-- 
Dieter