Wait, I have put you wrong there.
Can you please copy and paste here the output of print liney[-1]
Thanks,
Liam
On 4/16/06, Liam Clarke <[EMAIL PROTECTED]> wrote:
> 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
