Path: csiph.com!usenet.pasdenom.info!news.etla.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed4.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail Return-Path: X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org X-Spam-Status: OK 0.001 X-Spam-Evidence: '*H*': 1.00; '*S*': 0.00; 'from:addr:yahoo.co.uk': 0.04; 'element': 0.07; 'lawrence': 0.09; 'received:80.91': 0.09; 'received:80.91.229': 0.09; 'received:gmane.org': 0.09; 'received:list': 0.09; 'language.': 0.14; 'books': 0.15; '"python': 0.16; 'comma': 0.16; 'etc...': 0.16; 'filename,': 0.16; 'grasp': 0.16; 'posting,': 0.16; 'received:80.91.229.3': 0.16; 'received:plane.gmane.org': 0.16; 'silly': 0.16; 'subject:sqlite3': 0.16; 'tuple': 0.16; 'tuple.': 0.16; 'language': 0.16; 'wrote:': 0.18; 'all,': 0.19; 'trying': 0.19; 'pointed': 0.19; 'header:User-Agent:1': 0.23; 'subject:problem': 0.24; 'url:moin': 0.24; 'header:X-Complaints-To:1': 0.27; 'header :In-Reply-To:1': 0.27; 'tried': 0.27; 'point': 0.28; 'correct': 0.29; 'have,': 0.30; 'code': 0.31; 'url:wiki': 0.31; 'url:python': 0.33; 'subject: (': 0.35; 'subject:with': 0.35; 'something': 0.35; 'no,': 0.35; 'but': 0.35; 'really': 0.36; 'thanks': 0.36; "i'll": 0.36; 'url:org': 0.36; 'being': 0.38; 'to:addr:python-list': 0.38; 'files': 0.38; 'to:addr:python.org': 0.39; 'received:org': 0.40; 'how': 0.40; 'read': 0.60; 'such': 0.63; 'our': 0.64; 'more': 0.64; 'regards.': 0.65; 'hour': 0.70; 'lack': 0.78; 'convinced': 0.93 X-Injected-Via-Gmane: http://gmane.org/ To: python-list@python.org From: Mark Lawrence Subject: Re: sqlite3 docbug (was problem with sqlite3) Date: Thu, 23 Jan 2014 09:04:09 +0000 References: <52e07f45$0$3631$426a34cc@news.free.fr> <1f13ee0c-5cb5-4627-9f38-2058a8235083@googlegroups.com> <52E0C6B2.1000407@hotmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Gmane-NNTP-Posting-Host: host-92-24-222-18.ppp.as43234.net User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:24.0) Gecko/20100101 Thunderbird/24.2.0 In-Reply-To: <52E0C6B2.1000407@hotmail.com> X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: General discussion list for the Python programming language List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Newsgroups: comp.lang.python Message-ID: Lines: 34 NNTP-Posting-Host: 2001:888:2000:d::a6 X-Trace: 1390467873 news.xs4all.nl 2916 [2001:888:2000:d::a6]:56745 X-Complaints-To: abuse@xs4all.nl Xref: csiph.com comp.lang.python:64584 On 23/01/2014 07:37, lgabiot wrote: > Thanks to all, > > that was indeed the tuple issue! > the correct code is: > >>>cursor = conn.execute("SELECT filename, filepath FROM files WHERE > max_level > as was pointed out by many. > > Sorry for missing such a silly point (well, a comma in fact). I'll learn > to read more seriously the doc, but I was really confused (I spent more > than one hour trying so many combinations, reading the doc, books I > have, etc... before posting, and I was stuck) > > but the basis for my blindness was more a lack of grasp of the > fundamentals: how to declare a one element tuple. > Because I tried to write (threshold) being convinced it was a tuple... > > I need to remember at all times: https://wiki.python.org/moin/TupleSyntax > > best regards. > No, you need to remember how to type xyz into your favourite search engine. For this case xyz would be something like "python single element tuple". -- My fellow Pythonistas, ask not what our language can do for you, ask what you can do for our language. Mark Lawrence