[Zope] strange sql-results

4 May 2004

      I'm using zsql-methods for retriving data from an aida-database
suddenly(?) twho of my methods have started showing emty tables. the sql is:
(ID and IID is one of the fields in the table)

Arguments: ReportID

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)

Any clues?

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