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

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 = (

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.