[Tutor] Handling 'None' (null) values when processing sqlite cursor results
Monte Milanuk
memilanuk at gmail.com
Wed Jul 14 06:31:44 CEST 2010
Hello all,
I'm struggling a bit trying to find the right way to deal with null
values in my sqlite database when querying it and processing the results
in python.
If my cursor.fetchall() results return the following:
(104, None, u'Sylvester', None, u'Evans', None, u'527-9210 Proin Av.',
u'Liberal', u'VT', u'24742', u'1-135-197-1139',
u'vehicula.Pellentesque at idmollis.edu', u'2010-07-13 22:52:50',
u'2010-07-13 22:52:50')
At first I was having fits as str.join() was giving me a 'NoneType
error'. I found one way around that, by processing the results so the
'None' values got omitted from the list by the time they got to str.join().
I thought that was the end of that, until I tried working with the
returned records in another fashion and found that having the 'None'
values omitted really messed with the list order which I was depending
on i.e. list[5] could be different fields depending on how many 'None'
values had been omitted. And if I didn't omit them, when I printed out
the user name in the format 'first''middle''last' from the above record,
I got 'Sylvester''None''Evans' rather than just 'Sylvester''Evans' (i.e.
with no middle initial).
So... I guess my question is, is there a good/proper way to handle the
'None' values as returned by sqlite from a table that may have some null
values in individual records? Basically I want not have the None/Null
values show up but to keep them as place holders to make sure i get the
values in the right spots...
TIA,
Monte
More information about the Tutor
mailing list