[Pyado-users] Help!

[Mark R. <Mar...@di...>]

Am extremely new to Python and have encountered the following problem.
If I have more than
3 field names to INSERT into I get the following error message:
'Syntax error in INSERT INTO statement.', None, 5003134, -2147217900),
None).

With 3 or less fields, no problems.

Any help would be much appreciated (code listed below). Am running
Python 2.2.3

Thanks.

Mark


import PyADO
conn =
PyADO.connect(None,user='admin',password='',host=None,database='C:/ssts/validation/bulk_email/All_Schools_Tracking.mdb',provider='Microsoft.Jet.OLEDB.4.0')
curs = conn.cursor()

f = open("c:\ssts\ssw_reports\SSW_Mod20040301.txt")
for l in f.readlines():
        k = l.replace("\t", "nob")
        k = k.split("nob",12)
              
        d1 = k[0]
        d2 = k[1]
        d3 = k[2]
        d4 = k[3]

        zlst = [
               (d1,d2,d3,d4)
        ]

        for r in zlst:
            sql = """INSERT INTO nobber (Anumber, ChangeCode, Name,
Level)
                VALUES ('%s','%s','%s','%s')""" % r
            curs.execute(sql)
f.close
conn.close()