[Zope] strange sql-results

Einar Næss Jensen einar.jensen at hf.ntnu.no
Tue May 4 08:25:47 EDT 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




More information about the Zope mailing list