Re: [Zope] strange sql-results

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