problem with appending to a list, possibly mysqldb related

[John Salerno]

John Purser wrote:
> 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.
> 

Well, that makes sense! I guess it just didn't occur to me that some 
entries would have no first name, but I was ignoring all the obvious 
signs! :)