[Zope] strange sql-results

[Dieter Maurer]

Einar Næss Jensen wrote at 2004-5-4 14:25 +0200:
> ...
>SELECT * FROM Item WHERE ReportID=<dtml-sqlvar ReportID type="int">
>AND (IPage ="Sammendrag" OR IPage ="Summary") ORDER BY ID
>
>this shows an emty table
>
>
>however:
>SELECT * FROM Item WHERE ReportID=<dtml-sqlvar ReportID type="int">
>AND (IPage ="Sammendrag" OR IPage ="Summary") ORDER BY IID
>
>gives me the table (but sorted on the wrong key)

Are you using "ZODBCDA"?

Someone else reported similar incomprehensible differences
in SQL results with "ZODBCDA". The problem disappeared
when he switch to "mxZODBCDA".

-- 
Dieter