John Purser wrote: > On Thu, 31 Aug 2006 18:39:45 GMT > John Salerno <[EMAIL PROTECTED]> 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! :) -- http://mail.python.org/mailman/listinfo/python-list
