Checkout what query is sent to your database and try the same queries from the command line. ...very unlikely a Zope problem. -aj --On Dienstag, 4. Mai 2004 14:25 Uhr +0200 Einar Næss Jensen <einar.jensen@hf.ntnu.no> wrote:
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?