[orm-devel] select problem
Werner F. Bruhin
Fri Feb 28 13:52:34 CET 2003
I checked if I get the correct result using kinterbasdb directly with
the following little script.
cur = con.cursor()
cur.execute("SELECT test.id,test.winename FROM test WHERE id=45")
#cur.execute("SELECT* FROM test")
The select with the where clause returns the right column.
Debugging ORM I do not see when the fetchxxx (one or all is called).
Will go and make myself a tea, maybe that will clear up my vision!
Have fun with Firebird on Linux.
Diedrich Vorberg wrote:
>>debug output is: SELECT test.id,test.winename FROM test WHERE id=45
>>Any hints/help would be appreciated.
>Try running the query on a plain cursor to see if it returns the
>dataset you'd expect. Use the selectone() method of the cursor and
>check the tuple that's returned. That's exactly what orm does just a
>couple more functioncalls involved..:-)
>I'll set up firebird on Linux today and try it myself. Untill than I
>can't say much more.
More information about the orm-devel