Path: csiph.com!usenet.pasdenom.info!aioe.org!news.stack.nl!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
Return-Path: <antoon.pardon@rece.vub.ac.be>
X-Original-To: python-list@python.org
Delivered-To: python-list@mail.python.org
X-Spam-Status: OK 0.012
X-Spam-Evidence: '*H*': 0.98; '*S*': 0.00; 'received:134': 0.05; 'subject:into': 0.09; 'subject:string': 0.09; 'subject:How': 0.10; 'stored': 0.12; "'data'": 0.16; 'columns': 0.16; 'fetch': 0.16; 'inserting': 0.16; 'iterable': 0.16; 'nick': 0.16; 'subject:already': 0.16; 'sys.exit(0)': 0.16; 'typeerror:': 0.16; 'header:User-Agent:1': 0.23; 'skip:" 40': 0.26; 'header:In-Reply- To:1': 0.27; 'tried': 0.27; 'function': 0.29; 'host': 0.29; 'subject:list': 0.30; 'too.': 0.31; 'didnt': 0.31; 'file': 0.32; 'lists': 0.32; 'there.': 0.32; 'point.': 0.35; 'but': 0.35; 'nov': 0.38; 'to:addr:python-list': 0.38; 'to:addr:python.org': 0.39; 'skip:u 10': 0.60; 'act': 0.63; 'information': 0.63; 'miss': 0.74; 'pardon': 0.84; 'visit,': 0.84; 'subject:add': 0.91
X-IronPort-Anti-Spam-Filtered: true
X-IronPort-Anti-Spam-Result: AqAEAOvmeFKGuA9G/2dsb2JhbABZgz+DW7wygT+DGgEFI1URCxoCBRYLAgIJAwIBAgFFEwgCh32rbYktiRSBKY43FoJVgUQDmAqBL4R6i2CDJw
Date: Tue, 05 Nov 2013 13:42:19 +0100
From: Antoon Pardon <antoon.pardon@rece.vub.ac.be>
User-Agent: Mozilla/5.0 (X11; Linux i686; rv:10.0.12) Gecko/20130116 Icedove/10.0.12
MIME-Version: 1.0
To: python-list@python.org
Subject: Re: How to add a current string into an already existing list
References: <l52pdo$k0f$1@dont-email.me>	<mailman.1951.1383398828.18130.python-list@python.org>	<l5391q$9in$1@dont-email.me> <bdm7fiF28rrU1@mid.individual.net>	<roy-D613E2.07164103112013@news.panix.com> <l58k1t$24a$1@dont-email.me>	<l59842$roj$1@dont-email.me> <l5a4no$21s$1@dont-email.me>	<l5a8vu$iaa$1@dont-email.me>	<mailman.2041.1383639718.18130.python-list@python.org>	<l5abnk$v9u$1@dont-email.me> <l5acl9$qgm$1@speranza.aioe.org>	<l5ae3r$aie$1@dont-email.me> <l5afbl$ft4$1@dont-email.me>	<mailman.2047.1383646833.18130.python-list@python.org>	<l5ahib$rel$1@dont-email.me> <5278db56$0$29972$c3e8da3$5496439d@news.astraweb.com> <l5ao43$tg6$1@dont-email.me>
In-Reply-To: <l5ao43$tg6$1@dont-email.me>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
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.2052.1383655340.18130.python-list@python.org>
Lines: 27
NNTP-Posting-Host: 2001:888:2000:d::a6
X-Trace: 1383655340 news.xs4all.nl 15913 [2001:888:2000:d::a6]:43060
X-Complaints-To: abuse@xs4all.nl
Xref: csiph.com comp.lang.python:58501

Op 05-11-13 13:25, Nick the Gr33k schreef:
> 
> # fetch those columns that act as lists but are stored as strings
> cur.execute('''SELECT refs, visits, downloads FROM visitors WHERE
> counterID = %s and host = %s''', (cID, host) )
> data = cur.fetchone()
>        
> print( type(data) )
> sys.exit(0)
> 
> i tried inserting a type function to notify me of the datatype of 'data'
> but that didnt help too.
> 
> Still:
> [Tue Nov 05 14:22:32 2013] [error] [client 176.92.96.218]   File
> "/home/nikos/public_html/cgi-bin/metrites.py", line 268, in <module>
> [Tue Nov 05 14:22:32 2013] [error] [client 176.92.96.218]     (ref,
> visit, download) = data
> [Tue Nov 05 14:22:32 2013] [error] [client 176.92.96.218] TypeError:
> 'NoneType' object is not iterable
> 
> Unfortunately i still miss your point.

*Read* the documentation of fetchone! The information you need is there.

-- 
Antoon Pardon