[Zope-DB] MaxDB Problems - Pls Help
dieter at handshake.de
Tue Jan 13 13:43:45 EST 2004
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
>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.
More information about the Zope-DB