lite] "no such column" problem with multi level sub queries
Date: Fri, 14 Jul 2006 12:46:26 +0100
MIME-Version: 1.0
Received: from sqlite.org ([67.18.92.124]) by bay0-mc2-f13.bay0.hotmail.com
with Microsoft SMTPSVC(6.0.3790.2444); Fri, 14 Jul 2006 04:48:31 -0700
Received: (qmail 23254 in
No doubt Igor or one of the others will be able to explain *why* your
SQL fails but changing line 1 from
> 1: SELECT testlog.error,
to
> 1: SELECT error,
works with Python 2.5 using the built-in sqlite (3.3.4) on XP and with
Python 2.4 and pysqlite (2.8.16) on Debian Sarge.
Martin
John Cr
Apologies for the below statement:
Seems the culprit is line 5's testlog.error. It doesn't seem to see a 3
level deep SELECT. Running from line 2.
I was trying to modify the query line and forgot to clean my email. But the
statement about "3 level deep" stays. :-)
Thanks,
John
Ori
3 matches
Mail list logo