[Zope] strange sql-results

[Einar Næss Jensen]

Andreas Jung wrote:

> Checkout what query is sent to your database and try the same queries 
> from the command line.
> ...very unlikely a Zope problem.
>
Maybe.
the same query using mysql command-line gives me the correct output, 
same in phpmyadmin.
the mysql log says the query sent was this:
select * from Item where ReportID=13489 AND IPage="sammendrag" ORDER BY ID

so I'm left with somethin strange in zope/zsql-method
W recently switched to zope 2.7.0, and it was after that this "bug" 
appeared.
I "fixed it" by removing the "order by ID"-part.
but I still wonder....


-- 
Einar Næss Jensen
Avdelingsingeniør IT-HF
735 90750