[Zope] strange sql-results

Andreas Jung andreas at andreas-jung.com
Tue May 4 08:35:36 EDT 2004


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 at 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?







More information about the Zope mailing list