problem with appending to a list, possibly mysqldb related

[John Purser]

On Thu, 31 Aug 2006 18:39:45 GMT
John Salerno <johnjsal at NOSPAMgmail.com> wrote:

> John Salerno wrote:
> > John Purser wrote:
> > 
> >> I'd say you had a record with a null value for the namefirst field.
> >> The join method don't like that.  
> > 
> > Wow, you're right! I tried this:
> > 
> > if x[0] and not x[0] == 'NULL':
> > 
> > and sure enough it works after that. (Not sure if that's the best
> > way to test, though. Just testing for NULL still produced the
> > error, so I guessed that some namefirst fields were actually blank.)
> 
> Just tried again with:
> 
> if x[0]:
> 
> and that worked, so I guess NULL isn't a string value.
> -- 
> http://mail.python.org/mailman/listinfo/python-list
Your original python error was telling you that .join() didn't like
receiving a 'NoneType'.  Try entering type(None) from the python prompt.

By the time Python is seeing it it's not a MySQL null, it's a python
None.

-- 
You have a strong desire for a home and your family interests come
first.