|
From: Mark R. <Mar...@di...> - 2004-03-30 04:54:26
|
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()
|