[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