471,596 Members | 849 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,596 software developers and data experts.

Python checking for None/Null values

Okay, I have been handed a python project and working through it I have

had to add a report. I am returning 10 variables the results of an SQL
Query
and as usual the number of results vary from 1 result to 10 results so
I
implemented a check to see if the array item was empty or not. The code

is below based upon the code already in the python project i was
handed.

history8=historyRep[8]
if history8!=None:
history8=cmi.format_history(historyRep[8])
else:
history8=''

and

if historyRep[8]!=None:
history8=cmi.format_history(historyRep[8])
else:
history8=''

but regardless i am getting the error below and i can't seen to resolve
this, what am i
doing wrong?

Traceback (most recent call last): File
"/home/phillipsd/work/medusa-new/htdocs/pricingrep.cgi", line 326, in ?
if historyRep[8]==None: IndexError: list index out of range
David P

Aug 11 '06 #1
8 4854
In <11*********************@m73g2000cwd.googlegroups. com>, Fuzzydave
wrote:
but regardless i am getting the error below and i can't seen to resolve
this, what am i
doing wrong?

Traceback (most recent call last): File
"/home/phillipsd/work/medusa-new/htdocs/pricingrep.cgi", line 326, in ?
if historyRep[8]==None: IndexError: list index out of range
`historyRep` seems to be shorter than you think it is. Try printing it
too see what it actually contains.

Ciao,
Marc 'BlackJack' Rintsch
Aug 11 '06 #2
`historyRep` seems to be shorter than you think it is. Try printing it
too see what it actually contains.

Ciao,
Marc 'BlackJack' Rintsch
HistoryRep is an array value so historyRep[0] to [7] all have values
in them but historyRep[8] and [9] do not as the query does not always
return a full 10 values. I am trying to check all of the historyRep
items
to check if they are empty/null/None (whatever the term is in python)
and make it return an empty value or a none to the screen. I did print
historyRep[8] out and it falls over, I am assuming if its an array and
if the SQL query only returns 8 records instead of 10 then the last
two array values i am checking for litterly don't exist instead of
being
null but i can't find a if exists style function either?

David P

Aug 11 '06 #3
Check with "if history8 is not None". Won't help your problem, but it
is a bit more pythonic code ;-)

Sybren
Actually i tried that as well when i was fooling around, atm i am less
concenred
with pythonic code and making it work in the first place. The entire
program to
be fair is a bit messy but i do agree on the basis that the easier the
code is to
read the easier it is to work with.

David P

Aug 11 '06 #4
Fuzzydave:
I am trying to check all of the historyRep items
to check if they are empty/null/None (whatever the term is in python)
An item can't be empty in Python,and null doesn't exist, it can be the
object None. But probly that's not your case.

I did print
historyRep[8] out and it falls over, I am assuming if its an array and
if the SQL query only returns 8 records instead of 10 then the last
two array values i am checking for litterly don't exist instead of
being null but i can't find a if exists style function either?
A way to solve your problem is to see how many elements the list
contains with
len(sequence)
then act accordingly with the elements that exist.
Even better is to work on the elements that exist, with something like:
for element in sequence:
do_stuff

Note: sometimes having a clean and readable program is better than
having a running program that you can't read, because you can fix the
the first one, and it can teach you something.

Bye,
bearophile

Aug 11 '06 #5
Note: sometimes having a clean and readable program is better than
having a running program that you can't read, because you can fix the
the first one, and it can teach you something.

Bye,
bearophile
Thanks for your help and suggestions i'll give them a shot.

Unfortunatly when working with 6 years of other peoples legacy code
(esspecially *this* code) it sometimes looks like it was specifiyed in
the
project spec *not* to be readable :)

But I will endevour to change that while working with it myself ;)

David P

Aug 11 '06 #6
Fuzzydave wrote:
>
HistoryRep is an array value so historyRep[0] to [7] all have values
in them but historyRep[8] and [9] do not as the query does not always
return a full 10 values. I am trying to check all of the historyRep
items
to check if they are empty/null/None (whatever the term is in python)
and make it return an empty value or a none to the screen. I did print
historyRep[8] out and it falls over, I am assuming if its an array and
if the SQL query only returns 8 records instead of 10 then the last
two array values i am checking for litterly don't exist instead of
being
null but i can't find a if exists style function either?
Just paste this in immediately after getting the result back from the
query; it's not necessarily the fastest way but it's effin' obvious
what it's doing :-)

while len(historyRep) < 10:
historyRep.append(None)

Cheers,
John

Aug 11 '06 #7
Fuzzydave wrote:
Okay, I have been handed a python project and working through it I have
had to add a report. I am returning 10 variables the results of an SQL
Query and as usual the number of results vary from 1 result to 10 results
so I implemented a check to see if the array item was empty or not. The
code is below based upon the code already in the python project i was
handed.
In Python list items do not magically spring into existence if you ask for
them. Therefore items[index] raises an IndexError if index is >=
len(items). A possible resolution is to check the length of historyRep
first:

if len(historyRep) 8 and historyRep[8] is not None:
history8 = cmi.format_history(historyRep[8])
else:
history8 = ""

Note that names like history8 are a strong indication that you should use a
list rather than individual variables, e. g:

history = []
for item in historyRep:
if item is None:
s = ""
else:
s = cmi.format_history(item)
history.append(s)

or maybe even

history = [cmi.format_history(item) for item in historyRep]

if historyRep doesn't contain any None values.

Peter

Aug 11 '06 #8
be************@lycos.com wrote:
A way to solve your problem is to see how many elements the list
contains with
len(sequence)

cheers after your post went of to try it and it worked first time
thanks
for being helpful and plesant :)

Fuzzy

Aug 11 '06 #9

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Andrew Dalke | last post: by
10 posts views Thread by Python_it | last post: by
2 posts views Thread by ajikoe | last post: by
reply views Thread by Kurt B. Kaiser | last post: by
12 posts views Thread by p.lavarre | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by Anwar ali | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.