MySQLdb problem: inserting values

[rhitam30111985]

hi all .. consider the following code: i basically need to build a table in the mysql database with two fields , country and office list...

import MySQLdb
import sys
import os
 
os.system('clear')
try:
    conn = MySQLdb.connect (host = "localhost",
                        user = "root",
                        passwd = "neptune",
                        db = "mysql")
except MySQLdb.Error, e:
    print "Error %d: %s" % (e.args[0], e.args[1])
    sys.exit (1)
cursor = conn.cursor ()
officelist={'india':['infosys','accenture','TCS','microsoft'],
        'USA':['apple','microsoft','dupont','accenture']
           }
for item in officelist:
    li=' '.join(officelist[item])
    cursor.execute ("""
           INSERT INTO office_list (country, offices)
           VALUES
            (item,li)
                    """)
 
 
 

but i am getting an error File "./check.py", line 21, in ?
cursor.execute ("""
File "/var/lib/python-support/python2.4/MySQLdb/cursors.py", line 166, in execute
self.errorhandl er(self, exc, value)
File "/var/lib/python-support/python2.4/MySQLdb/connections.py" , line 35, in defaulterrorhan dler
raise errorclass, errorvalue
_mysql_exceptio ns.OperationalE rror: (1054, "Unknown column 'item' in 'field list'")

now it looks like i need to pass string values to the two fields country and offices in the cursor.execute( ) statement ... how do i pass the corresponding key,value from the dictionary officelist?

[rhitam30111985]

oops.. hey all.. never mind .. found solution.. :

    cursor.execute ("INSERT INTO office_list (country, offices)VALUES(%s,%s)",(item,li))
 

but now new problem has come up: the values are getting truncated for the offices column.. how do i create an infinite length field ?

[bartonc]

oops.. hey all.. never mind .. found solution.. :

    cursor.execute ("INSERT INTO office_list (country, offices)VALUES(%s,%s)",(item,li))
 

but now new problem has come up: the values are getting truncated for the offices column.. how do i create an infinite length field ?

Infinite, huh??? There are limits. As in the 4GB text type "LONGTEXT". For more a reasonable limit, use "TEXT" (64KB).

Of course, I'm speaking of the column types in your DB. Nothing to do with what you are doing in your program.