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. -- You have a strong desire for a home and your family interests come first. -- http://mail.python.org/mailman/listinfo/python-list
