Re: SQLite and coercing to Unicode - please help.

2007-09-06 Thread Steve Holden
special_dragonfly wrote: > That helped immensely Steve thank you. You're right, this is my first really > big project ever really, not just in Python. > Just to clarify, my UPDATE statement instead of looking like this: > > longstring="UPDATE SecB SET > currencyCode='"+Values[1]+"',issuerName='"

Re: SQLite and coercing to Unicode - please help.

2007-09-06 Thread special_dragonfly
That helped immensely Steve thank you. You're right, this is my first really big project ever really, not just in Python. Just to clarify, my UPDATE statement instead of looking like this: longstring="UPDATE SecB SET currencyCode='"+Values[1]+"',issuerName='"+Values[2] "',instrName='"+Values[3]

Re: SQLite and coercing to Unicode - please help.

2007-09-06 Thread Steve Holden
special_dragonfly wrote: > Hello! > First, the problem: the program below falls over with the following error: > TypeError: coercing to Unicode: need string or buffer, NoneType found. > and gives the following line: > "' WHERE secBoardId='"+Values[0]+"'" > My first thought was that Values[0] was co