Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!newsfeed0.kamp.net!newsfeed.kamp.net!feeder1.cambriumusenet.nl!feed.tweaknews.nl!85.12.40.139.MISMATCH!xlned.com!feeder7.xlned.com!newsfeed.xs4all.nl!newsfeed4.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path: <rosuav@gmail.com>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.005
X-Spam-Evidence: '*H*': 0.99; '*S*': 0.00; 'subject:query': 0.07; 'exception,': 0.09; 'cc:addr:python-list': 0.11; 'jan': 0.12; '23,': 0.16; 'exactly?': 0.16; 'filename,': 0.16; 'from:addr:rosuav': 0.16; 'from:name:chris angelico': 0.16; 'iterable,': 0.16; 'subject:sqlite3': 0.16; 'wrote:': 0.18; 'thu,': 0.19; 'not,': 0.20; 'cc:addr:python.org': 0.22; 'integer': 0.24; 'please?': 0.24; 'subject:problem': 0.24; 'cc:2**0': 0.24; 'post': 0.26; 'header:In-Reply-To:1': 0.27; "doesn't": 0.30; 'message-id:@mail.gmail.com': 0.30; '>>>>': 0.31; 'subject:with': 0.35; 'received:google.com': 0.35; 'so,': 0.37; 'files': 0.38; 'pm,': 0.38; 'telling': 0.64; 'subject:SQL': 0.84; 'to:none': 0.92
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:cc :content-type; bh=VuhktxZ4OolqUnoEUasjylm/rQCAYzkGXbymS1gY+C4=; b=b6BDmfvL56StoAHqY25RKyzNfP1NT4DnR05kNUHaTOLj055OJAHNJh3+yeTdxWyrBx vbEICH+v7DBHTrKqh/iqQHJLVzqns9lOu4fDOjw6+IXnwNPhebntG2/srQiMNJpRcHmM B5QC2jcbRlvtBZgu9ET4asDVdj5Pg9AP5zXG1hfmJb17udw7xXzz9WxyQ28uGlGb+iu9 +X51aSK8XbSn1VWOio2kkzl+5/zq4WY6nIa8eKL3oavIy03FZgrUZln3zXGqu+UyAWxw B+3kNFprfAAIFlUvIWq2C8IbyLnXACLIdh6hzzmkrvALuxTsSQDnMf62wK/xjhacS+JI vx4w==
MIME-Version: 1.0
X-Received: by 10.66.66.234 with SMTP id i10mr5267034pat.127.1390444922272; Wed, 22 Jan 2014 18:42:02 -0800 (PST)
In-Reply-To: <52e07f45$0$3631$426a34cc@news.free.fr>
References: <52e07f45$0$3631$426a34cc@news.free.fr>
Date: Thu, 23 Jan 2014 13:42:02 +1100
Subject: Re: problem with sqlite3: cannot use < in a SQL query with (?)
From: Chris Angelico <rosuav@gmail.com>
Cc: "python-list@python.org" <python-list@python.org>
Content-Type: text/plain; charset=UTF-8
X-BeenThere: python-list@python.org
X-Mailman-Version: 2.1.15
Precedence: list
List-Id: General discussion list for the Python programming language <python-list.python.org>
List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe>
List-Archive: <http://mail.python.org/pipermail/python-list/>
List-Post: <mailto:python-list@python.org>
List-Help: <mailto:python-list-request@python.org?subject=help>
List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe>
Newsgroups: comp.lang.python
Message-ID: <mailman.5861.1390445378.18130.python-list@python.org>
Lines: 10
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1390445378 news.xs4all.nl 2866 [2001:888:2000:d::a6]:59894
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:64558

On Thu, Jan 23, 2014 at 1:32 PM, lgabiot <lgabiot@hotmail.com> wrote:
>>>>cursor = conn.execute("SELECT filename, filepath  FROM files WHERE
>>>> max_level<(?)", threshold)
> that doesn't work (throw an exception)

What exception, exactly? Was it telling you that an integer is not
iterable, perhaps? If so, check your docs for conn.execute(). If not,
can you post the exact exception, please?

ChrisA