Figured out my autoincrement problem

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Figured out my autoincrement problem

dannykmcdaniel
I originally had the "NULL" value as the first item in
the each row of newitems. I moved it down to the
values list as shown below and it works. thanks to all
who thought about this 'problem' with me.




newitems = (
            (32,2,20,0,0,0),
            (34,2,20,0,0,0)
     
           )

for items in newitems:
    cur.execute("insert into budgets (budget_id,
cost_id, project_id, original_budget, \
    revised_budget,committed,actual_spent) \
    values (NULL, ?,?,?,?,?,?)", items)



               
__________________________________
Yahoo! FareChase: Search multiple travel sites in one click.
http://farechase.yahoo.com