would be helpful to paste the entire error information that python gives ..
including the lines before and after.
When pytho sets an error , it will tell you *exactly* where the error is
at (or it should) I do all my development work on Linux, havent worked
with ODBC databases, but the reference to a list of tuples , almost
makes me thing the SQL needs to be a full insert:
(insert into tablename (field1,field2.....) values (value1,value2....) )
John CORRY wrote:
> Thanks Brian for the help on the last one. I couldn’t see the wood for
> the trees. I have a tougher one for you.
>
>
>
> I am reading in a CSV file. Each line represents a line that I want to
> upload into my database. I am trying to upload the first line in the
> file to get myself started. The code is below:-
>
>
>
> import string, re
>
> path = "c:/test/import.csv"
>
> listy = []
>
> input = file(path, "r")
>
> for line in input.readlines():
>
> line = line.split(",")
>
> listy.append(line)
>
>
>
> print listy[-1]
>
>
>
> stat = """Insert into cost_grid values
> (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
>
> ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
>
> ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,
>
> ?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,)"""
>
> t = 5000
>
> d = "PF2"
>
> b = 91.4
>
> a = 95.00
>
>
>
> import mx.ODBC
>
> import mx.ODBC.Windows
>
> db = mx.ODBC.Windows.DriverConnect('DSN=vfp')
>
> c = db.cursor()
>
> c.execute(stat, listy[-1])
>
>
>
> db.commit()
>
> c.close()
>
>
>
> I get the following error:
>
>
>
> TypeError: parameters must be a list of tuples
>
>
>
> Any suggestions would be greatly appreciated.
>
>
>
> Thanks,
>
>
>
> John.
>
> !DSPAM:444178de174651249418164!
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> Tutor maillist - Tutor@python.org
> http://mail.python.org/mailman/listinfo/tutor
>
>
> !DSPAM:444178de174651249418164!
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
