* Lukasz Szybalski <[EMAIL PROTECTED]> [2006-04-14 12:00:09 -0500]: > INSERT INTO table_x( body)VALUES( '%s')" % (body) > > this body is a string that varies in size. I keep getting an error if > the size of body is longer then 255, and if its smaller everything > goes smooth. Is this syntax correct? should '%s' be something else?
What is the datatype of body? It sounds like it is CHAR(255). Can you change this to be TEXT? Regards, Andy Send instant messages to your online friends http://uk.messenger.yahoo.com _______________________________________________ DB-SIG maillist - DB-SIG@python.org http://mail.python.org/mailman/listinfo/db-sig