Hi John,
Listy will be a list of lists, and the DBAPI specifies tuples. So
either change this -
listy.append(line)
to
listy.append(tuple(line))
or stick a list comprehension at the end if you need to mung anything
in listy before passing it in:
listy = [ tuple(item) for item in listy]
Regards,
Liam Clarke
On 4/16/06, John CORRY <[EMAIL PROTECTED]> 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.
> _______________________________________________
> Tutor maillist - Tutor@python.org
> http://mail.python.org/mailman/listinfo/tutor
>
>
>
_______________________________________________
Tutor maillist - Tutor@python.org
http://mail.python.org/mailman/listinfo/tutor
