[Zope] strange sql-results

[Einar Næss Jensen]

Dieter Maurer wrote:

>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"?
>  
>
No. Only ZMysqlDa

>Someone else reported similar incomprehensible differences
>in SQL results with "ZODBCDA". The problem disappeared
>when he switch to "mxZODBCDA".
>
>  
>
I reinnstalled Mysql-python.. It now works. (someone else have been 
innstalling warious adapters for MSSQL,
However: Later I ran a check on my tables and it found several duplicate 
keys (which should be uniqe) for the field i wanted to sort.
I think maybe something was wrong with my tables.

Best regards
EInar Næss Jensen

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