[Tutor] School Boy Error

[Brian Gustin]

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 at python.org
> http://mail.python.org/mailman/listinfo/tutor
> 
> 
> !DSPAM:444178de174651249418164!