[SQLObject] SQLObject / Interbase, generated SQL defective
SQLObject is a Python ORM.
Brought to you by:
ianbicking,
phd
From: Frank W. <fra...@no...> - 2010-04-15 13:56:39
|
hi everyone! it´s been a while but i hope you will answer me. in a script i have a sqlobject query like this: r.BUCHUNGEN.filter((Gebucht.q.PERSONEN >= 4) & (Gebucht.q.OPTIONSDATUM is None)) this generates sql like this: SELECT gebucht.NR, [...] FROM gebucht WHERE ((((gebucht.REISENR) = ('10CAL/1604')) AND (((gebucht.STORNIERT) = ('NEIN')) OR ((gebucht.STORNIERT) IS NULL))) AND (((gebucht.PERSONEN) >= (4)) AND (0))) this won´t be executed by the interbase server, it doesn´t accept the last part "AND (0)" and dismisses the query. if i remove this last part it will execute just fine. is this a sqlobject-issue? or is it rather kinterbasdb related? thanks! frank |