On Apr 5, 11:41 am, [EMAIL PROTECTED] wrote: > On Apr 5, 10:31 am, "erikcw" <[EMAIL PROTECTED]> wrote: > > > Hi, > > > I'm trying to build a SQL string > > > sql = """INSERT INTO ag ('cid', 'ag', 'test') VALUES(%i, %s, %d)""", > > (cid, ag, self.data[parent][child]['results']['test']) > > > It raises this error: AttributeError: 'tuple' object has no attribute > > 'encode' > > > Some of the variables are unicode (test and ag) - is that what is > > causing this error? What do I need to do to make it work? > > > Thanks! > > Erik > > It sounds like you're not calling the "encode" method correctly. But > it's hard to say when you didn't include that bit of code. You may > need to check your database's docs to make sure it accepts unicode > strings and if so, what types (utf-8, 16, 32). > > See this post for a similar problem: > > http://lists.modevia.com/archives/py-transports/2005-December/001719.... > > and this link details tuple > usage:http://www.faqs.org/docs/diveintopython/odbchelper_tuple.html > > Mike
I tried adding .encode("utf-8") onto each of the variables in the tuple, but that didn't seem to help. The error just changes slightly to AttributeError: 'long' object has no attribute 'encode' I'm using Mysql. -- http://mail.python.org/mailman/listinfo/python-list